Formulas: Adding Months

dbin78 · Aug 5th 2003

How do I add months? Such as, todays date it 08/05/03, how do I add three months to make it 11/05/03?

Thank Youm

Anonymous · Aug 5th 2003

This should work: (EDITED)

=DATE(YEAR(TODAY()),MONTH(TODAY())+3,DAY(TODAY()))

dbin78 · Aug 5th 2003

Thank You,

What would it be to use a date in a cell?
If i enter any given date and want to add three months.
Cell A1 = 02/02/03
Cell A2 = A1+3 months????

Thanks

rem1224 · Aug 5th 2003

Try this -

=DATE(YEAR(A1),MONTH(A1)+3,DAY(A1))

...Ralph

2rrs · Aug 5th 2003

[quote]Originally posted by dbin78
Thank You,

What would it be to use a date in a cell?
If i enter any given date and want to add three months.
Cell A1 = 02/02/03
Cell A2 = A1+3 months????

Thanks [/quote

Try this:

=EDATE(A1,3)

Anonymous · Aug 6th 2003

Note: EDATE will only work if the Analysis Tool Pack add-in that comes with Excel is open.

Participate now!