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