To do this the formula is similar to the one for when dates are in the future, it is just tweaked a bit to show the difference. You are subtracting the date in the past from today’s date.

How to subtract in different cells If you have numbers located in different cells in your spreadsheet that you want to subtract, you can do so by using cell references and a formula.

Subtracting isn’t as straightforward in Excel as it seems, simply because there’s no actual command to subtract numbers. Instead, you have to use a formula with the subtraction operator.

Excel formulas are essential for unlocking the full potential of the program. If you're new to Excel and curious about what formulas are and how they work, hereâ s everything you need to know.