Editing Talk:2676: Historical Dates
Please sign your posts with ~~~~ |
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone.
Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 23: | Line 23: | ||
In Excel, January 1, 1900 is 1. However, December 30, 1899 is the "epoch" date that you should use if you want to convert a current date (anything on or after March 1, 1900) to a number by "subtracting" the current date minus the epoch date (counting the number of days since the epoch date). The reason it isn't December 31 is because of the above mentioned bug where Excel counts February 29, 1900 as a day even though it actually isn't. | In Excel, January 1, 1900 is 1. However, December 30, 1899 is the "epoch" date that you should use if you want to convert a current date (anything on or after March 1, 1900) to a number by "subtracting" the current date minus the epoch date (counting the number of days since the epoch date). The reason it isn't December 31 is because of the above mentioned bug where Excel counts February 29, 1900 as a day even though it actually isn't. | ||
::I just checked it in different versions of Excel, you are right. Meanwhile LO Calc it is Dec 31th 1899... I'll try to edit the explaination to make it more universal. [[User:Asterisk|Asterisk]] ([[User talk:Asterisk|talk]]) 21:11, 24 September 2022 (UTC) | ::I just checked it in different versions of Excel, you are right. Meanwhile LO Calc it is Dec 31th 1899... I'll try to edit the explaination to make it more universal. [[User:Asterisk|Asterisk]] ([[User talk:Asterisk|talk]]) 21:11, 24 September 2022 (UTC) | ||
− | |||
Speaking of dates, shouldn’t this one be in the category “Saturday comics”? Or was it still Friday in Hawaii when it came out? [[Special:Contributions/162.158.107.246|162.158.107.246]] 17:57, 24 September 2022 (UTC) | Speaking of dates, shouldn’t this one be in the category “Saturday comics”? Or was it still Friday in Hawaii when it came out? [[Special:Contributions/162.158.107.246|162.158.107.246]] 17:57, 24 September 2022 (UTC) |