Google Sheets
TODAY function in Google Sheets
Returns the current date as a date value.
=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 Excel
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 Google Sheets gets this done.
- DATEConverts a provided year, month, and day into a date.DateExcel
- DATEDIFCalculates the number of days, months, or years between two dates.DateExcel
- DATEVALUEConverts a provided date string in a known format to a date value.DateExcel
- DAYReturns the day of the month that a specific date falls on, in numeric format.DateExcel
- DAYSReturns the number of days between two dates.DateExcel
- DAYS360Returns the difference between two days based on the 360 day year used in some financial interest calculations.DateExcel