Question: how do you subtract a date from today in excel?
Answer: Click in a blank cell and type = then click on the cell with the future date. Subtract and type in TODAY(). The result is displayed as a date. Open the Format Cells dialog box and change the date to a number.