Show the current date (or date and time) that updates automatically.
Copy this formula
=TODAY()TODAY() returns the current date and recalculates each day; NOW() returns the date and time. Both are volatile, so they refresh when the workbook recalculates. For a fixed timestamp, type the date or press Ctrl+;.
=TODAY()+30→2026-07-2330 days from today.
Date and time
=NOW()Includes the current time.
TODAY()/NOW() always update. For a static stamp, copy the cell and Paste Special ▸ Values, or use Ctrl+; (date) / Ctrl+Shift+; (time).
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.