This is the Excel document formatted. 3] Dates are in the past. Here you will see how to subtract from today if the date or dates you want to use are in the past.

In our case, we have to sum the data in the cells B2 to B6, hence, the formula is: =B2+B3+B4+B5+B6. Similarly, you can create a formula to subtract data in Excel.

Excel provides two options for calculating the difference between two dates. You can use a simple subtraction operation such as "=B2-A2" to calculate the amount of days between those two calendar ...

How to subtract in Excel using cell references. You don't have to subtract numbers in a single cell; you can also set up a formula that will subtract the values stored in multiple cells.