ExcelFlux

TODAY function

TODAY returns the current system date when the workbook recalculates.

Date and time

Where can you use it?

Planning and operations teams. Use this group to work with dates and times in calendars, delivery schedules, shifts and period reporting.

Scenario in the workbook

Compare today’s date serial with the integer part of NOW.

A worked example from the workbook

RowA
6Trial
71
82
93
Record 1
=TODAY()=INT(NOW())

Expected resultTRUE

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=B2-TODAY()
Turkish Excel · tr-TR
=B2-BUGÜN()

Sample data

Enter the headers and sample records in A1:B2.

Task Due date
Review =TODAY()+3

Format B2 as a date and C2 as Number or General.

Enter the formula in C2.

To try the Turkish formula, use the sample data on the Turkish page.

Expected result

3 days

How it works

Subtracting two dates gives a difference in days. Enter yesterday’s date in B2 to get −1. Use TODAY() for a dynamic date. Enter a fixed date value when it must be retained unchanged.

Syntax

TODAY()

Compatibility

Excel for Microsoft 365 and Excel 2016, 2019, 2021, and 2024.

Worked examples

Compare today’s date serial with the integer part of NOW.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A
6 Trial
7 1
8 2
9 3
Case Formula Expected result
Record 1 =TODAY()=INT(NOW()) TRUE
Record 2 =TODAY()=INT(NOW()) TRUE
Record 3 =TODAY()=INT(NOW()) TRUE
Microsoft Excel reference