DATE

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Walter - 06 Mar 2007 18:25 GMT

Can anyone tell me the right formulae to add up days, months and years to an
existing date? I know it works with DATE() but for some mysterious reason it
doesn't work with me.
It's simple yet:
2007-03-06
+ xxx days
+ xxx months
+ xxx years
and that sum should give me the right answer.
Please...

Reply to this Message

Roger Govier - 06 Mar 2007 18:30 GMT

Hi Walter

With 2007-03-06 in cell A1
=DATE(YEAR(A1)+x,MONTH(A1)+y,DAY(A1)+z)
where x is the number of years to add, y the number of months and z the
number of days.
These could equally be cell references holding the appropriate figures.

Signature

Regards

Roger Govier

> Can anyone tell me the right formulae to add up days, months and years
> to an
[quoted text clipped - 8 lines]
> and that sum should give me the right answer.
> Please...

Reply to this Message