How to Use the TODAY Function in Excel to Display the Current Date Automatically

If you're building a report, a timesheet, or a dashboard in Excel, you’ll often want to show the current date. That’s where the TODAY() function shines. It updates automatically every time the worksheet recalculates.

🧪 Syntax:

=TODAY()

This formula has no arguments. Just type it in and press Enter.

📘 Example Uses:

• Daily Reports: Auto-stamp the current date on your summary page.
• Expiration Notices: Calculate how many days left until a deadline:
  =A1 - TODAY() → If A1 is a future date, this tells how many days are left.
• Age Calculation:
  =DATEDIF(B1, TODAY(), "Y") → Age in years from birthdate in B1.

🔁 When Does It Update?

Every time the file is opened or the worksheet is recalculated. It always reflects the **current date**.

📅 Format Tip:

After using =TODAY(), apply a date format like DD-MM-YYYY from the Home > Number > Date section to make it readable.

⚠️ Caution:

• It is volatile – It recalculates frequently, which may slow large workbooks.
• It returns only the date, not the time.
• For date & time, use =NOW().

📌 Final Thoughts

The TODAY() function is simple yet powerful. Whether you’re automating reports or building schedules, this tiny formula keeps your work timely and relevant—every single day.

🎁 Want a ready-to-use daily tracker template? Download one now from ScriptDataInsights on Gumroad.