I can't get Excel to caluate dates in the 1800's. #VALUE!

[KenB]

I am using a date 3-9-1857. I want to add a number of days to that date and
see what it is. I can do this with dates after 1-1-1900, but not before
that. I just get #VALUE! in that column. Is there anyway I can work with
dates before 1900 ?

 

[Niek Otten]

Look here:

http://www.j-walk.com/ss/excel/files/xdate.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am using a date 3-9-1857. I want to add a number of days to that date and
| see what it is. I can do this with dates after 1-1-1900, but not before
| that. I just get #VALUE! in that column. Is there anyway I can work with
| dates before 1900 ?