Add dates

Microsoft Office Excel 2003

Use the addition (+) operator to do this task.

Worksheet example

The example may be easier to understand if you copy it to a blank worksheet.

Create a blank workbook or worksheet.
Select the example in the Help topic. Do not select the row or column headers.

Selecting an example from Help
Press CTRL+C.
In the worksheet, select cell A1, and press CTRL+V.
To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Tools menu, point to Formula Auditing, and then click Formula Auditing Mode.

1

2
3
4

A	B
Date	Days to add
6/9/2007	3
=TODAY()	5
12/10/2008	54
Formula	Description (Result)
=A2+B2	Add 3 days to 6/9/2007 (6/12/2007)
=A3+B3	Add 5 days to the current day (varies)
=A4+B4	Add 54 days to 12/10/2008 (2/2/2009)

Show Add a number of months to a date

Use the DATE, YEAR, MONTH, and DAY functions to do this task.

Worksheet example

This example can be copied on to a blank worksheet.

Show How?

Create a blank workbook or worksheet.
Select the example in the Help topic. Do not select the row or column headers.

Selecting an example from Help
Press CTRL+C.
In the worksheet, select cell A1, and press CTRL+V.
To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Tools menu, point to Formula Auditing, and then click Formula Auditing Mode.

1

2
3
4

A	B
Date	Months to add
6/9/2007	3
9/2/2007	5
12/10/2008	25
Formula	Description (Result)
=DATE(YEAR(A2),MONTH(A2)+B2,DAY(A2))	Add 3 months to 6/9/2007 (9/9/2007)
=DATE(YEAR(A3),MONTH(A3)+B3,DAY(A3))	Add 5 months to 9/2/2007 (2/2/2008)
=DATE(YEAR(A4),MONTH(A4)+B4,DAY(A4))	Add 25 months to 12/10/2008 (1/10/2011)

Function details

Show Add a number of years to a date

Use the DATE, YEAR, MONTH, and DAY functions to do this task.

Worksheet example

The example may be easier to understand if you copy it to a blank worksheet.

Show How?

Create a blank workbook or worksheet.
Select the example in the Help topic. Do not select the row or column headers.

Selecting an example from Help
Press CTRL+C.
In the worksheet, select cell A1, and press CTRL+V.
To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Tools menu, point to Formula Auditing, and then click Formula Auditing Mode.

1

2
3
4

A	B
Date	Years to add
6/9/2007	3
9/2/2007	5
12/10/2008	25
Formula	Description (Result)
=DATE(YEAR(A2)+B2,MONTH(A2),DAY(A2))	Add 3 years to 6/9/2007 (6/9/2010)
=DATE(YEAR(A3)+B3,MONTH(A3),DAY(A3))	Add 5 years to 9/2/2007 (9/2/2012)
=DATE(YEAR(A4)+B4,MONTH(A4),DAY(A4))	Add 25 years to 12/10/2008 (12/10/2033)

Function details

Show Add a combination of days, months, and years to a date

Use the DATE, YEAR, MONTH, and DAY functions to do this task.

Worksheet example

The example may be easier to understand if you copy it to a blank worksheet.

Show How?

Create a blank workbook or worksheet.
Select the example in the Help topic. Do not select the row or column headers.

Selecting an example from Help
Press CTRL+C.
In the worksheet, select cell A1, and press CTRL+V.
To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Tools menu, point to Formula Auditing, and then click Formula Auditing Mode.

1

2

A
Date
6/9/2007
Formula	Description (Result)
=DATE(YEAR(A2)+3,MONTH(A2)+1,DAY(A2)+5)	Add 3 years, 1 month, and 5 days to 6/9/2007 (7/14/2010)
=DATE(YEAR(A2)+1,MONTH(A2)+7,DAY(A2)+5)	Add 1 year, 7 months, and 5 days to 6/9/2007 (1/14/2009)

The formula above has the following arguments.

Formula to add dates

Callout 1 start_date: a date or reference to a cell that contains a date

Callout 2 add_year: the number of years to be added

Callout 3 add_month: the number of months to be added

Callout 4 add_day: the number of days to be added

Function details

previous page start next page