| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel date bug?
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel date bug?
|
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change date in excel from today to original date of file | Excel Discussion (Misc queries) | |||
| Change satellite julian date format YYYYDDDHHMMSS to excel date ti | Excel Discussion (Misc queries) | |||
| Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
| Make date change in excel to current date when opening daily? | Excel Discussion (Misc queries) | |||
| Date stamp spreadsheet in excel to remind me of completion date | Excel Worksheet Functions | |||
Linear Mode
