Question: how to subtract dates in excel using today?
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.