Excel
TODAY function in Excel
Returns the serial number of today's date
=TODAY()TODAY examples
Formulas you'll actually reuse.
Today's date, with no time part — updates each day the file opens:
=TODAY()Days until an invoice is due (negative once it's overdue):
=C2 - TODAY()
TODAY in Google Sheets
Same name — your formula ports as-is.
Try TODAY in the playground
Edit the example — nothing to install.
Preloaded with the TODAY formula from Example 1 — change anything and watch it respond.
Loading the editor…
Related functions
More ways Excel gets this done.
- DATEReturns the serial number of a particular dateDateGoogle Sheets
- DATEDIFCalculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age.DateGoogle Sheets
- DATEVALUEConverts a date in the form of text to a serial numberDateGoogle Sheets
- DAYConverts a serial number to a day of the monthDateGoogle Sheets
- DAYSReturns the number of days between two datesDateGoogle Sheets
- DAYS360Calculates the number of days between two dates based on a 360-day yearDateGoogle Sheets