Dates before 1900


C

clueless in nj

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.
 
Ad

Advertisements

N

Nick Hodge

Excel will only work with dates from 1900 anything earlier will be text

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top