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

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.

--
Regards

Roger Govier


"Walter" wrote in message
...
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...