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.

1] How to subtract multiple cells in Excel by using a formula Here we will talk about how to subtract data arranged in multiple cells in a particular row and column from a single cell in Excel.