Skip to content

Excel function · Date & time

Excel TODAY function

TODAY takes no arguments and returns today's date, updating whenever the file opens or recalculates. It is the basis of anything measured against today: days to a due date, age, length of service.

In Turkish Excel: BUGÜN

What it does

=TODAY() is written with empty brackets and returns the date only, with no time. Because Excel stores dates as numbers, the result can be added to, subtracted from and compared with other dates: =B2-TODAY() gives the days left until a due date.

TODAY is volatile: it recalculates every time the file opens and whenever the sheet changes. That makes it unsuitable for recording the day an invoice was issued, because the cell changes the next day. If you need a fixed date, type it in, or copy the formula and use Paste Values.

If you also need the time, use NOW. TODAY is often combined with DATEDIF for completed years and months, NETWORKDAYS for working days and EDATE for a date a few months ahead.

Syntax

English Excel=TODAY()
Turkish Excel=BUGÜN()

Arguments in square brackets are optional. English Excel separates arguments with commas (,) and uses a dot for decimals; Turkish Excel uses semicolons (;) and a decimal comma. Excel shows function names in its own language when it opens the file.

Arguments

ArgumentRequiredDescription

Examples

1Days to the due date and overdue status

Column C subtracts today from the due date; the result is the number of days left and turns negative for an overdue invoice. Column D writes a status from that number. The results on this page are based on 5 November 2026.

C2fx=B2-TODAY()
Days to the due date and overdue status: example table
ABCD
1InvoiceDue DateDays LeftStatus
2F-204120-Nov-202615Pending
3F-20435-Nov-20260Due today
4F-204528-Oct-2026-8Overdue
5F-204715-Dec-202640Pending
  • C2 (filled down to C5)=B2-TODAY()
  • D2 (filled down to D5)=IF(C2<0,"Overdue",IF(C2=0,"Due today","Pending"))

F-2041 has 15 days to go. For the overdue F-2045 the result is negative (-8) and the status is Overdue; F-2043, due today, shows Due today. Open the file tomorrow and every number drops by one.

Results are as of 5 November 2026; on that day we recalculated them in real Excel (Microsoft 365, 16.0) and they matched.

2Years of service up to today

DATEDIF counts the completed years from the start date to today. The results are based on 5 November 2026 and recalculate each day the file is opened.

C2fx=DATEDIF(B2,TODAY(),"y")
Years of service up to today: example table
ABC
1EmployeeStart DateService (Years)
2Emma2-Mar-201511
3Liam5-Nov-20197
4Olivia6-Nov-20214
5Noah17-Jun-20242
  • C2 (filled down to C5)=DATEDIF(B2,TODAY(),"y")

Today is Liam's work anniversary, so he reaches a full 7 years. Olivia started one day later and is still at 4; tomorrow she moves up a year too.

Results are as of 5 November 2026; on that day we recalculated them in real Excel (Microsoft 365, 16.0) and they matched.

Common errors and fixes

Difference shown as a date

Cause: The result of =B2-TODAY() appears as a date such as 15/01/1900 because the cell picked up a date format.

Fix: Set the cell format to General or Number; the result is a number of days.

Record date keeps changing

Cause: An invoice date was entered with TODAY, so it changed when the file was opened the next day.

Fix: Type record dates in by hand, or fix the formula with Paste Values.

#VALUE!

Cause: The date column holds dates stored as text that Excel cannot read as dates, so they cannot be subtracted from TODAY.

Fix: Convert them to real dates; to build them from parts, use DATE.

Good to know

  • To see delays as positive numbers, use =TODAY()-B2; to show only overdue days, use =MAX(0,TODAY()-B2) (MAX).
  • If Calculation Options are set to Manual, TODAY does not refresh by itself; press F9 to recalculate.

In Nexell

Get Nexell to do it from a sentence

Type this in Nexell

Add a column to the invoice list showing how many days are left until each due date, and a status column that says "Overdue" when the due date has passed

Convert to table

Bring your invoice list into the tool and type this. Nexell adds both columns with real Excel formulas and shows them in the preview; in the downloaded file, the days left update by themselves every day.

Nexell uses AI to understand the request and builds the result with real Excel formulas; the formula may differ from the example on this page. You see a preview first and nothing changes until you press Apply; formulas stay live in the downloaded .xlsx file.

Free account · no card needed · 30 credits a month

Frequently asked questions

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

Type the date straight into the cell, or enter =TODAY(), then copy the cell and use Paste Values. A cell that keeps the TODAY formula changes every day.

How do I calculate age in Excel?

With the date of birth in B2, =DATEDIF(B2,TODAY(),"y") gives the age in completed years (DATEDIF). For age with decimals, use =YEARFRAC(B2,TODAY(),1).

Related functions

All date & time functions →

Stop memorising formulas. Describe them.

Bring your table into the tool and say what you need; Nexell builds the formula and shows it in a preview.

Try it free