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
| Row | A |
|---|---|
| 6 | Trial |
| 7 | 1 |
| 8 | 2 |
| 9 | 3 |
=TODAY()=INT(NOW())Expected resultTRUE
See the inputs and instructions for all 3 examplesCopyable formulas
=B2-TODAY()=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.
Related pages
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 |