LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cox cox is offline
external usenet poster
 
Posts: 3
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sumifs - incorrect when using date in critera Kathy Excel Worksheet Functions 3 November 19th 08 05:39 PM
My Apologies For An Incorrect Date On My Computer Danno Excel Worksheet Functions 0 October 12th 08 03:53 AM
Date Format incorrect [email protected] Excel Discussion (Misc queries) 0 March 29th 07 06:16 PM
Date incorrect in excel because Setting up and Configuration of Excel 2 January 11th 06 01:18 PM
Incorrect Date formatting dionne_w Excel Discussion (Misc queries) 2 February 22nd 05 09:31 PM


All times are GMT +1. The time now is 04:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"