NOW Formula in Excel

What this does

TODAY returns the current date; NOW returns the date with the time attached. Both are volatile: they recalculate whenever anything in the workbook changes, so a cell holding =TODAY() is not a record of when something happened, it is always "now". That is the single most consequential thing to know about them — a timestamp meant to stay put must be entered with Ctrl+; (date) or Ctrl+Shift+; (time), or pasted as a value. Their genuine use is anything that should move with the calendar: ageing an invoice, counting days remaining, driving a conditional format for overdue rows. Keep the inputs visible and clearly labelled and the whole thing stays auditable — anyone who opens the file later, including you, can see at a glance exactly what feeds the result and change one assumption without hunting through the formula. For “now formula in excel”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected formula change, and only then apply the same setup to the full sheet. When a formula is involved, keep the inputs labelled beside it, reference cells instead of typing values, and apply number formatting only after the result checks out. That is what makes a calculation you can defend to a CFO or an auditor useful in real work: repeatable, auditable, and not dependent on memory or luck.

A worked example

Days a receivable has been outstanding: =TODAY()-A2, formatted as a number rather than a date. Flagging overdue rows with conditional formatting: =AND(A2<TODAY(), B2<>"Paid"). Days remaining until a deadline: =A2-TODAY(). A static stamp instead — press Ctrl+; which types the date once and never changes it. TODAY and NOW are what make an ageing report age itself — and knowing they are volatile is what stops them being used as timestamps. One habit worth forming early: name the cells that hold your inputs, so the formula reads in plain language instead of a string of cell addresses. A reviewer — or you in three months — can then follow the logic without decoding what B7 and D2 were supposed to mean, which is most of what makes a sheet maintainable.

In Google Sheets

Everything above works in Google Sheets too. Excel and Sheets share the formula syntax used here; only the surrounding menus are arranged differently. That portability is deliberate — learn it once and it follows you between the two tools and across Windows and Mac. Nothing on this page is behind a login: the tool runs entirely in your browser, the formula is shown in full with one-click copy, and the steps work the same on Windows and Mac. That is the whole promise here — the exact answer, a way to prove it on your own numbers, and just enough context to make it stick. Treat “now formula in excel” as a small building block rather than a chore. Once the inputs sit in their own cells and the formula reads from them, the same setup answers a dozen related questions with a tweak, and Excel keeps every dependent figure current as the data changes. The tool above is there so you can rehearse and verify before committing anything to a real workbook; the steps and worked example are there so the logic sticks. Get it right once and it stops costing you time — it starts saving it, every time the question comes back around.

Common mistakes

• Using =TODAY() as a record of when something was entered, which rewrites itself every time the file opens.
• Formatting a date difference as a date, which shows 1900-01-15 instead of 14 days.
• Forgetting the brackets; =TODAY without them returns #NAME?.

Frequently asked questions