Show All
Add dates
Add a number of days to a date
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.
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.
|
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) |
|
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.
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.
|
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
DATE
YEAR
MONTH
DAY
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.
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.
|
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
DATE
YEAR
MONTH
DAY
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.
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.
|
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
start_date: a date or reference to a cell that contains a date
add_year: the number of years to be added
add_month: the number of months to be added
add_day: the number of days to be added
Function details
DATE
YEAR
MONTH
DAY