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

Similar Threads

Error in Excel date calculations 3
Dates before 1900 2
WORKDAYS 4
Formatting Dates from 1700 & 1800s 1
long dates before 1900 3
Dates before 1900 and Year function 1
dates older than 1900 2
Excel consider the day 29-02-1900 while it never happened 1

Top