Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Does Excel keep track of leap years when making date calculations


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default Does Excel keep track of leap years when making date calculations

Yep.

There is a bug, though. Excel thinks that 1900 was a leap year.



Rickmilv wrote:

--

Dave Peterson
Reply
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
Add a formated date button for Excel 2002 tool bar Mr. Low Excel Discussion (Misc queries) 1 October 30th 06 04:12 PM
holiday dates bucci Excel Worksheet Functions 4 June 15th 06 09:35 AM
How does Excel allow for leap years? Neil Excel Worksheet Functions 2 May 12th 06 09:16 AM
Excel ignores boot-time regional settings when interpreting a date [email protected] Excel Discussion (Misc queries) 2 November 4th 05 11:44 AM
Excel Adding years or months to a date Joan Excel Discussion (Misc queries) 2 April 25th 05 08:09 PM


All times are GMT +1. The time now is 10:34 PM.

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"