EDATE function - Add and subtract months to a specified date in Excel
The following article introduces you to the EDATE function - one of the functions in the date and time group function is very popular in Excel.
Description: The function performs addition (subtraction) of the month on the specified date. Use this function to calculate the due date that matches the release date in the month.
Syntax: EDATE (start_date, months)
Inside:
- start_date: The date represents the start date to add or subtract month values.
- months: The number of months to be added to start_date, the following cases:
+ months> 0 -> Create new days in the future.
+ months <0 -> Create new date in the past.
Attention:
- Excel stores the date as a serial number to facilitate the calculation process.
- If the start_date value is not a valid date -> the function returns the #VALUE! Error value
- Where the value moths is not an integer -> it is truncated to an integer.
For example:
Calculate the value of the day after adding or subtracting 1 month value in the table below:
- In the cell to calculate enter the formula: = EDATE (E7, F7).
- Press Enter -> days after 1/1/2011 1 month is:
- Similarly copying the formula for the remaining values results:
- Where the value of months is not an integer -> it is truncated to an integer.
The above are instructions and some specific examples when working with EDATE function in Excel.
Good luck!
You should read it
- How to subtract dates, months, and years in Excel - Calculate the distance between two dates in Excel
- How to use subtraction in Excel
- DATE function - The date function in Excel
- Excel date function - Usage and examples
- DAY function - The function returns the date value of a specific date in Excel
- How to calculate time in Excel: Add and subtract time
- How to Subtract in Excel
- NOW function - The function returns the current date and time in Excel
- Calculation of age from date of birth in Excel
- How to use the SUMIF function in Excel
- Instructions on how to insert the current date in Excel
- How to use the WORKDAY function in Microsoft Excel
Maybe you are interested
How to Fix Clipboard History Error in Windows 11 Latest Update
4 Ways to update Win 11 Driver, quick update tips
Microsoft makes major improvements to Windows Update, updates will be installed much faster
WinRAR 6.10 beta update fixes Windows 11 context menu bug
Windows updates constantly, why?
How to update graphics drivers in Windows 10 and 11