Excel Study · Module 7: Dates & times
Class 56TODAY & NOW
Intermediate2:09 videoFree
=TODAY() shows today's date and =NOW() the date and the time. Both are volatile: Excel works them out again every time it recalculates, so a sheet opened tomorrow shows tomorrow's date.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, B4 has a deadline date. Write a formula for B6 that gives the number of days left from today until the deadline, as a plain number, and that updates by itself every day.
The answer that works
✓ checked in Excel=B4-TODAY()
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.