DATE

  • Thread starter Thread starter Walter
  • Start date Start date
W

Walter

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