Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Incorrect Date function
Excel help says the following:
"Microsoft Excel stores dates as sequential numbers which are called serial values. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900. Excel stores times as decimal fractions because time is considered a portion of a day." This is wrong - there are 39,447 days between January 1, 1900 and January 1, 2008. The format function specifies February 29, 1900 was a Wednesday. There was no February 29 in 1900 because 1900 was not a leap year. Whoever wrote the date function did not know what is considered an elementary school knowledge that a year that is multiple of 100 is leap year if and only if it is a multiple of 400. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumifs - incorrect when using date in critera | Excel Worksheet Functions | |||
My Apologies For An Incorrect Date On My Computer | Excel Worksheet Functions | |||
Date Format incorrect | Excel Discussion (Misc queries) | |||
Date incorrect in excel | Setting up and Configuration of Excel | |||
Incorrect Date formatting | Excel Discussion (Misc queries) |