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

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?

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?

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

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?

--

Regards,

Peo Sjoblom

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