How To Use Today Excel Function Today S Date Examples
TODAY Function In Excel (Today’s Date) For example, suppose TODAY() returns the current date, e.g., 10-10-2020. Then, to add 7 days to today’s date, we can use the formula =TODAY()+7, which returns the result as 17-10-2020. Syntax Displaying the Current Time Using TODAY Function The TODAY formula in Excel displays the current time as a time serial number (or a serial number without an associated date): =NOW()-TODAY() You need to format the cell with a time format to view the result as a recognizable time....