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.