How to Use the TODAY Function in Excel to Display the Current Date Automatically 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**. 📅 ...