The date can be supplied directly to a formula in the format that Excel can understand or by using the DATE function or as a reference to the cell containing the date. This formula links to specific cells in the worksheet to source the formula parameters however you can also enter the number of days you want to subtract and the date that you want to subtract the days from by directly entering these parameters into the formula eg. Things to Remember About Subtract Date in Excel.
Keep in mind this will change when the file is opened again on a future day.
When you use the TODAY function Excel uses your computers current date for the date. If you change the number formatting of a cell that contains a date to General or Number you will see number between 1 and 40000. The date can be supplied directly to a formula in the format that Excel can understand or by using the DATE function or as a reference to the cell containing the date. Like this we can subtract dates in excel.