Subtracting Days from a Date in a Cell Subtracting a certain number of days from a given day is similar to adding it. In fact, the formulas remain the same, but instead of +N days, you’ll use -N days. Here are the examples: =A2-10 =DATE(2015, 9, 20)-10 =TODAY()-10 2. A...
Wrapping up, when it comes to subtracting dates in Excel and you want to find outhow many days are between two dates, it makes sense to go with the easiest and most obvious option - simply subtract one date directly from another. If you are looking to count the number ofmonths or years...
Subtracting daysfrom a date:=DATE(2015, 5, 20) - 15The result of the above formula is May 5, 2015, which is May 20, 2015 minus 15 days. To subtract a date from today's date:=TODAY()-DATE(2015,5,20)The formula calculates how many days are between the current date and some othe...
Assuming that you have the original dates to work with, enter the number of days that you want to add or subtract from the dates in that adjustment column. Enter a positive number to add to the date or a negative number to subtract from it. Next, go to the first cell in the column ...
1. Select a blank cell you will place the calculating result, type the formula =A2+10, and press the Enter key. Note: For subtracting 10 days from the date, please use this formula =A2–10.2. If you need to apply this formula to other cells, please drag the AutoFill handle of...
Subtracting Days from Date:If you want to get a backdate from a date a few days before, then just subtract that number of days from the date and you will get backdate. For example, if I want to know what date was before 56 days since TODAY then I would write this formula in the ...
You should not add two dates to get the future date, as it will sum up the serial numbers of those days and you may get a date far in the future.Subtracting Days from Date:If you want to get a backdate from a date a few days before, then just subtract that number of days from ...
Add or Subtract Days to Dates Using Formulas With formulas, you get a lot of flexibility while adding or subtracting dates. For example, you can add a different number of days to date by just having that number in an additional column. You can also only add the weekdays (while ignoring ...
We'll look at some simple examples here and tackle the more complex scenarios later when we look at Date and Time Functions. Adding/Subtracting Days from Dates Tip:you can also add/subtract the days directly in the formula e.g. =B10+10 or =B11-5 Although, it's better to place the ...
Add Days to a Date Dates in Excel are stored as serial numbers where each whole number represents a unique day: This makes adding or subtracting dates extremely easy. Simply add a number of days directly to the date: =B3+C3 Subtract Days From a Date ...