How to Subtarct Months to Date in Excel
If you want to add or subtract a certain number of whole months to a date, you can use the DATE or EDATE function:
Example : Subtract months to a date with Excel EDATE
Excel provides a specialized function called EDATE that simplifies the process of working with dates when adding or subtracting months. This function is available in all versions of Excel form 2007:
=EDATE( start_date, months)
Arguments:
Start_date – the start date from which to count the numbers of months.
Months- the number of months to add( a positive value) or subtract (a negative value).
The following formula used on our column of dates yields exactly the same result as the DATE function in the previous example:
Using Edate()
How to Add or Subtract Dates in Excel
Adding or subtracting dates has many use cases. In many situations, we need to use that. If we want to add a few days/months/years to a project’s schedule date to reschedule the date or you want to check how long a single activity in a list of particular activities will take to complete. You can use a simple formula to add or subtract a number of days from a date, worksheet functions in Excel can be used instead for date manipulation.