View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KenB KenB is offline
external usenet poster
 
Posts: 3
Default I can't get Excel to caluate dates in the 1800's. #VALUE!

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 ?