How can I add more than 800 days to a given date

H

hospice

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?
 
B

Bob Phillips

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)
 
P

Peo Sjoblom

Since one excel day = 1 you can definitely add 800 days to a date,
what's the result you get and what's the result you expect?
 
Top