What it does
In Excel a date is a whole number and a time is a fraction of a day: 5 November 2026 at 18:00 is stored as 46331.75. NOW returns the whole value, TODAY only the whole-number part. To see the time in the cell, it needs a date-time format (e.g. dd/mm/yyyy hh:mm).
NOW is volatile: it recalculates on every change and every time the file opens, and the clock moves on. So it does not keep the moment a record was entered. For the date part use =INT(NOW()) or simply =TODAY(); for the time part use =NOW()-TODAY() or HOUR.
The examples on this page do not depend on the time of day, and the results are based on 5 November 2026. In your own file, results based on NOW change with the moment of calculation.
Syntax
=NOW()=ŞİMDİ()Arguments in square brackets are optional. English Excel separates arguments with commas (,) and uses a dot for decimals; Turkish Excel uses semicolons (;) and a decimal comma. Excel shows function names in its own language when it opens the file.
Arguments
| Argument | Required | Description |
|---|
Examples
1Check quote validity regardless of the time of day
A quote is valid until the end of the day in column B. Column C drops the time part of NOW with INT before comparing; column D compares without dropping it and misses the last day. The results on this page are based on 5 November 2026.
=IF(INT(NOW())<=B2,"Valid","Expired")| A | B | C | D | |
|---|---|---|---|---|
| 1 | Quote | Valid Until | Status | Comparison with Time |
| 2 | QT-501 | 4-Nov-2026 | Expired | Expired |
| 3 | QT-502 | 5-Nov-2026 | Valid | Expired |
| 4 | QT-503 | 30-Nov-2026 | Valid | Valid |
- C2 (filled down to C4)
=IF(INT(NOW())<=B2,"Valid","Expired") - D2 (filled down to D4)
=IF(NOW()<=B2,"Valid","Expired")
QT-502, whose last day is today, shows Valid in C3. D3 takes the time of day into account and shows Expired: NOW is later than 5 November 00:00. Yesterday's QT-501 is Expired in both columns.
Results are as of 5 November 2026; on that day we recalculated them in real Excel (Microsoft 365, 16.0) and they matched.
2Flag this month's records
For a date to be in the current month, its year and its month must match those of NOW. YEAR and MONTH are compared separately and AND combines them. The results are based on 5 November 2026.
=AND(YEAR(A2)=YEAR(NOW()),MONTH(A2)=MONTH(NOW()))| A | B | C | D | |
|---|---|---|---|---|
| 1 | Date | Customer | Amount | This Month? |
| 2 | 30-Oct-2026 | North Market | 3,200 | FALSE |
| 3 | 2-Nov-2026 | Atlas Ltd | 1,850 | TRUE |
| 4 | 4-Nov-2026 | Blue Electric | 2,600 | TRUE |
| 5 | 12-Nov-2025 | West Build | 1,450 | FALSE |
- D2 (filled down to D5)
=AND(YEAR(A2)=YEAR(NOW()),MONTH(A2)=MONTH(NOW()))
The two rows from November 2026 show TRUE. The row from last November shows FALSE, because the year is compared too. At the start of December, all the flags change by themselves.
Results are as of 5 November 2026; on that day we recalculated them in real Excel (Microsoft 365, 16.0) and they matched.
Common errors and fixes
- Time not shown
Cause: Only the date appears because the cell is not in a date-time format.
Fix: Change the cell format to a date-time format such as
dd/mm/yyyy hh:mm.- Time stamp keeps changing
Cause: The moment a record was entered was written with NOW, so it updates on every recalculation.
Fix: Fix the value with Paste Values, or type it in.
- Expires a day early
Cause: The last valid day was tested with
NOW()<=B2; because the time of day counts too, the offer looks expired from the morning of its last day.Fix: Drop the time before comparing:
INT(NOW())<=B2orTODAY()<=B2.
Good to know
- To test whether a date falls in the current month, compare the year and the month separately:
=AND(YEAR(A2)=YEAR(NOW()),MONTH(A2)=MONTH(NOW())). - For a live time stamp at the top of a report, use
="Prepared: "&TEXT(NOW(),"dd/mm/yyyy hh:mm")(TEXT).
In Nexell
Get Nexell to do it from a sentence
Add a This Month column to the sales list that shows whether each row belongs to the current month
Convert to tableBring your sales list into the tool and type this. Nexell adds the column with real Excel formulas and shows it in the preview; in the downloaded file, the flags update by themselves when the month changes.
Nexell uses AI to understand the request and builds the result with real Excel formulas; the formula may differ from the example on this page. You see a preview first and nothing changes until you press Apply; formulas stay live in the downloaded .xlsx file.
Free account · no card needed · 30 credits a month
Frequently asked questions
What is the difference between NOW and TODAY?
TODAY returns the date only (with the time taken as 00:00); NOW returns the date and the current time together. Use TODAY for day counts and NOW when hours and minutes matter.