D6 is the cell where you wrote the date, the minus sign (-) before today tells Excel to subtract the date in the future (D6) from today’s date.

You will get a result of 120. To subtract in Excel, use a minus sign just like you would doing arithmetic on paper. Dave Johnson That's the same as if you did the same steps and entered: =50-10+100-20 ...