View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default How can I add more than 800 days to a given date

That should not be a problem. What is the numberformat of the cell with the
date in?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"hospice" wrote in message
...
I have to generate a report every 90, 90 and multiple 60 day increments.
After I get to the original date cell +800, the program will not add the

days
to arrive at the correct date. I can however convert the cell to a number
corresponding to the date in the previous cell, add 60, and it will figure
the date correctly and display it. Why, and is there a better work-around?