Add one month

[blither]

I'm more of an Access person so I'm used to the dateadd function. How do you add one month or one day to a date in Excel?

 

[Aladin Akyurek]

On 2003-02-10 14:46, blither wrote:
I'm more of an Access person so I'm used to the dateadd function. How do you add one month or one day to a date in Excel?

=A1+1 adds 1 day to date in A1.

=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)) adds 1 month.

=EDATE(A1,1) is identical to the latter and requires that the Analysis Tooolpak is activated.

 

[2rrs]

Hi, Try this.
The first one will add 1 month to A12; the second one or any number of years, months and/or days to A13. Your choice.

=EDATE(A12,1)

=DATE(YEAR(A13)+1, MONTH(A13)+1, DAY(A13)+1)

2rrs

 

[Legacy 12630]

On 2003-02-10 14:51, Aladin Akyurek wrote:

=A1+1 adds 1 day to date in A1.

=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)) adds 1 month.

=EDATE(A1,1) is identical to the latter and requires that the Analysis Tooolpak is activated.

The two latter formulas do not always produce the same result (because of different handling of months where the no. of days are not the same).

For example, if 1 month is to added to 30 Jan 2002, the "DATE" formula produces 2 March 2003 and the "EDATE" formula produces 28 Feb 2003.

 

[Aladin Akyurek]

On 2003-02-10 18:24, Ponsonby wrote:

On 2003-02-10 14:51, Aladin Akyurek wrote:

=A1+1 adds 1 day to date in A1.

=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)) adds 1 month.

=EDATE(A1,1) is identical to the latter and requires that the Analysis Tooolpak is activated.

The two latter formulas do not always produce the same result (because of different handling of months where the no. of days are not the same).

For example, if 1 month is to added to 30 Jan 2002, the "DATE" formula produces 2 March 2003 and the "EDATE" formula produces 28 Feb 2003.

Yep, quite true. These darn date and time things...

 

[Barry Katcher]

Yes, getting the right date was always a problem for me. But now that I'm getting older, it doesn't seem to matter as much.