How to Subtract or Add Days to Date in Excel
Whether you’re working with a single date or a list of dates, Excel makes it easy to add or subtract a specific number of day using basic arithmetic operations.
Adding Days to a Date in Excel
To add a certain number of days to a date, follow this general formula:
DATE+ N days
Below are some ways to input the date:
- Use a cell reference, e.g., ‘=A2 + 10’
- Utilize the ‘DATE(year, month, day)’ function e.g., ‘=DATE(2015, 5, 6) +10 ‘
- Leverage a function result. For example, to add days to the current date, use the ‘TODAY()’ Function: =’TODAY() +10′
Adding days to date
Subtracting Days form a Date in Excel
Subtracting days form a date is just as straightforward. It’s essentially the same process as addition, but with the minus sign:
Date – N days
Here are examples of how to do this:
- ‘=A2 -10’
- ‘=DATE(2015, 5, 6) – 10’
- ‘=TODAY() -10’
Subtract Days from date
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.
Contact Us