Excel 가이드

How to add months to a date in Excel

The EDATE function is the most efficient way to calculate a date that is a specific number of months before or after a starting date in Excel.

단계별

1
Select a cell
Click on the cell where you want the resulting date to appear.
2
Enter the EDATE formula
Type =EDATE(start_date, months) into the cell, replacing 'start_date' with your date cell and 'months' with the number of months to add.
3
Format the result
If the result appears as a number, go to the 'Home' tab, click the 'Number Format' dropdown, and select 'Short Date'.

=EDATE(A2, 3)

To subtract months, simply use a negative number for the 'months' argument (e.g., -3).

What if the result shows a serial number instead of a date?

Excel stores dates as serial numbers; simply change the cell format to 'Date' to display it correctly.