The TODAY function, one of Excel's date and time functions. can be used to add today's date to a spreadsheet. Normally worksheets recalculate each time they are opened so every day that the worksheet is opened the date will change unless automatic recalculation is turned off.