Thread: Excel date bug?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JMB JMB is offline
external usenet poster
 
Posts: 2,062
Default Excel date bug?

You meant 1/1/1900, not 1/1/1990?

" wrote:

Hi,

It seems that in Excel you can have 2/29/1900 although that day did not
exist?

That would mean that the number of days between 1/1/1990 and, say,
5/1/2006 is not 38838 or (38838-1, if you will) but rather 38837 or
(38837-1, if you will).

Correct?

Thanks!

Aaron Fude