Skip to content

Excel function · Date & time

Excel NOW function

NOW takes no arguments and returns the current date and time together, updating whenever the file recalculates. Use it for time-based durations and time-stamped reports.

In Turkish Excel: ŞİMDİ

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

English Excel=NOW()
Turkish Excel=Şİ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

ArgumentRequiredDescription

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.

C2fx=IF(INT(NOW())<=B2,"Valid","Expired")
Check quote validity regardless of the time of day: example table
ABCD
1QuoteValid UntilStatusComparison with Time
2QT-5014-Nov-2026ExpiredExpired
3QT-5025-Nov-2026ValidExpired
4QT-50330-Nov-2026ValidValid
  • 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.

D2fx=AND(YEAR(A2)=YEAR(NOW()),MONTH(A2)=MONTH(NOW()))
Flag this month's records: example table
ABCD
1DateCustomerAmountThis Month?
230-Oct-2026North Market3,200FALSE
32-Nov-2026Atlas Ltd1,850TRUE
44-Nov-2026Blue Electric2,600TRUE
512-Nov-2025West Build1,450FALSE
  • 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())<=B2 or TODAY()<=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

Type this in Nexell

Add a This Month column to the sales list that shows whether each row belongs to the current month

Convert to table

Bring 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.

Related functions

All date & time functions →

Stop memorising formulas. Describe them.

Bring your table into the tool and say what you need; Nexell builds the formula and shows it in a preview.

Try it free