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.

Dates before 1900
 

Please don't multi-post.
You have an answer in your other thread

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"clueless in nj" wrote in message
...
| 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.

Dates before 1900
 

John Walkenbach has an add-in to allow you to work with pre-1900
dates, available he

http://www.j-walk.com/ss/excel/usertips/tip028.htm

Alternatively, you could fool Excel by adding, say, 200 to the years
to bring them above 1900.

Hope this helps.

Pete

On Dec 9, 8:44 pm, "Niek Otten" wrote:
Please don't multi-post.
You have an answer in your other thread

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"clueless in nj" wrote in ...
| 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.