The TODAY function

Returns today's date. It updates every time the sheet recalculates.

How to use TODAY

TODAY returns today's date from your computer's clock. It takes no arguments, so you always write it with empty parentheses: =TODAY(). Think of a wall calendar that turns its own page every morning.

That makes it the starting point for any calculation based on today's date. Days left until a deadline: =B2-TODAY(). How old an invoice is: =TODAY()-A2. Whether something is overdue: =IF(B2<TODAY(),"Overdue","OK"). A person's age in whole years: =DATEDIF(A2,TODAY(),"y"). A contract reminder: =IF(B2-TODAY()<=30,"Renew soon","").

Dates are numbers underneath, one step per day, so you can add and subtract days directly: =TODAY()+14 is two weeks from now. For whole months, combine TODAY with EDATE or EOMONTH, as in =EOMONTH(TODAY(),0) for the last day of this month.

TODAY recalculates whenever the sheet does, so the date moves on each day you open the file. If you need a date that stays put, such as the day an invoice was written, type it in or copy the cell and paste it as a value. When you need the time as well, use NOW instead.

Syntax

TODAY()

Examples

B1=ISNUMBER(TODAY())
AB
1TRUE
B1=IF(TODAY()>DATE(2020,1,1),"After 2020","Before")
AB
1After 2020

Common TODAY mistakes

  • The date on my invoice changes every day

    TODAY is live, so it shows the date of the day you open the file. For a date that stays fixed, type the date or copy the cell and paste it as a value.

  • I get a date in 1900 instead of a number of days

    When you subtract two dates, the cell often keeps a date format. Set the format of the result cell to Number or General, and =B2-TODAY() shows the days.

  • The age calculation is off around birthdays

    Dividing days by 365 ignores leap years, so the result slips. Use =DATEDIF(A2,TODAY(),"y"), which counts whole years.

  • TODAY returns #NAME?

    The parentheses are missing. TODAY needs them even though they stay empty: =TODAY(), not =TODAY.

Read the guide

Questions

How do I insert today's date so it does not change?

Press Ctrl+; (semicolon) in a cell to enter the current date as a fixed value. You can also copy a cell with =TODAY() and paste it as a value.

How do I get today's date and the time?

Use =NOW(). It returns the date and the current time, and like TODAY it recalculates whenever the sheet does.

How do I count the days between a date and today?

Subtract the date from today: =TODAY()-A2 for the days since A2, or =A2-TODAY() for the days left until A2. Format the result as a number.

Why is TODAY not updating?

TODAY updates when the sheet recalculates. If calculation is set to manual, press F9 to update it, or switch calculation back to automatic.

How do I calculate age from a birth date?

Use =DATEDIF(A2,TODAY(),"y") for the age in whole years. Add a second formula with "ym" instead of "y" if you also want the extra months.

Related functions