Adding dates

[Natalie]

Hi,

How do I add dates in Excel -

Cell 1 Cell 2
10/03/04 I want to put 6 months from Cell 1 date.

I know i can add the days, but can I make it too return 10/09/04?

Thanks

 

[Arvi Laanemets]

Hi

=MIN(DATE(YEAR(A1),MONTH(A1)+6,DAY(A1)),DATE(YEAR(A1),MONTH(A1)+7,0)
returns the date 6 months from date in cell A1, or when there is less days
in future month then day number in A1, then the last day in month 6 months
of date in A1.

When you have Analysis Toolpack Add-in installed, then you can use
=EDATE(A1,6)
which does exactly same as first formula.