Adding months to a date range

[Lou2001]

I have a column(B for example) with different dates. In column (C) I need to add these dates plus six months. For example if 1c is July 6th, 2001. I need to add six months to this so that column 1d shows Januaray 6th,2002. How can I do this? Also I ned another column showing +12 months.

 

[Aladin Akyurek]

On 2002-04-10 09:33, Lou2001 wrote:
I have a column(B for example) with different dates. In column (C) I need to add these dates plus six months. For example if 1c is July 6th, 2001. I need to add six months to this so that column 1d shows Januaray 6th,2002. How can I do this? Also I ned another column showing +12 months.

=EDATE(A1,6)

will add 6 months to the date in A1.

You need the Analysis Toolpak (via Tools|Add-Ins) if EDATE is not available.

Alternatively:

=DATE(YEAR(A1),MONTH(A1)+6,DAY(A1))
This message was edited by Aladin Akyurek on 2002-04-10 10:03