Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates before 1900
I'm trying to get a very simple DATADIF formula to work. I subtracted the
start date from the end date of each employee to get the total number of days they were employed. This works fine for dates after 1900, but anything from the 1700 or 1800's results in a value error. Is there any way I can trick excel into calculating these values? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dates Before 1900 | Excel Worksheet Functions | |||
Pre-1900 dates | Excel Discussion (Misc queries) | |||
Dates before 1900 | Excel Worksheet Functions | |||
Dates prior to 1900 | Excel Worksheet Functions | |||
calculate with dates before 1-1-1900 | Excel Worksheet Functions |