View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
supoch14 supoch14 is offline
external usenet poster
 
Posts: 25
Default Dates before 1900



"clueless in nj" wrote:

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.