Creating formulas to subtract values in Excel is straightforward to start with, but as you can see it has some advanced uses. Getting to grips with basic math in spreadsheets can help you make the ...

The Excel formula you would use would be formulated as =cell number with date – today (). You will plug in your cell references that match your information.

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.