=NOW() returns a current date/time value in the file’s time zone. Unlike TODAY(), which represents the current date at midnight, NOW includes the time of day. The result is refreshed when the file opens or a table changes; it should not be treated as an unchanging time stamp. Apple’s NOW documentation says it takes zero arguments and still requires both parentheses.

Use NOW for a workbook that needs a live, recalculated time display, an elapsed-time or overdue indicator, or a volatile status relative to a deadline. Do not confuse the current date/time on a shared Numbers document with an automatically certified audit time: the workbook’s file time zone can depend on how and where it was created or saved.

=NOW()

The current clock reading cannot have a reproducible single answer for readers at different moments. Formatting the output to include hours and minutes lets you inspect the date-time rather than only its date. Apple’s page does not promise updating each second in an open, idle document; it specifically mentions file-opening and table-changing events.

Create a Numbers table named ClockAudit. In row 1 enter headers A Event, B Value, C Interpretation. Supply the following row 2–6 formulas exactly as listed, and apply Date & Time formatting to B2 if it only shows a date.

Do not use ClockAudit::B6 as a historical test result; it depends on a live workbook. B2:B5 are genuine formulas, and all human-readable outputs remain conditional on the file’s clock and refresh event. Numbers was not available for native execution in this research.

Controlled check of the downstream time functions

To verify the separate extraction logic without guessing the actual clock, use an independently constructed time with =TIME(16,45,30): =HOUR(TIME(16,45,30)) is expected 16, =MINUTE(TIME(16,45,30)) is expected 45, and =SECOND(TIME(16,45,30)) is expected 30. These numeric results were checked against the fixed input components, but the expressions themselves have not been executed in Numbers.

Deadline alert based on current date/time

Put a real date-time deadline in ClockAudit::B7 (enter it with the Numbers date/time editor). Then use =IF(NOW()>B7,"Past deadline","Not yet past"). The status is relative to when NOW was last evaluated; it is not a reliable historical record of when the deadline first elapsed. If exact sub-second precision, time-zone conversions or regulated audit evidence are required, use a dedicated timestamping process and validate it separately.

Safer report designs

For a historical report, store an explicitly captured As-of date/time value in a controlled source cell and base every metric on that value instead of NOW. This prevents opening a report later from changing its conclusion. If one workbook has multiple NOW() calls, referencing a single B2 cell can also make your formulas clearer and document the intended common clock value without asserting undocumented recalculation atomicity.

The official NOW page identifies these scopes:

• Local macOS document: the file zone follows the Mac’s Date & Time settings as of the last save.
• Local iPhone or iPad document: the file zone follows the device Date & Time settings on open or save.
• iCloud document: initial iCloud file settings determine the zone; a subsequent open/save in a local app can replace it with device settings.
• Shared collaboration document: the zone continues to follow the iCloud location where first shared until unsharing and saving locally changes it.

This explains why one reader’s wall clock can disagree with a collaborative file’s value near day boundaries. The documentation does not supply a full daylight-saving test matrix; do not claim one without native and time-zone-specific checks.

Apple documents copying a NOW formula cell and using Edit > Paste Formula Results. The described result is fixed text, not a live NOW formula. If downstream software expects a real sortable date-time value, test the pasted value’s type and format rather than assuming universal automatic date parsing. For irreversible audit trails, verify any further requirements about source-of-truth, permissions and edit history separately.

• NOW without parentheses: enter =NOW(); an empty argument list is intentional.
• Clock has today’s date but no visible hours: inspect Date & Time formatting of the result cell.
• Time doesn’t advance every second: Apple promises refresh when the file opens or a table changes, not continuous ticking.
• Different results across devices: investigate the Numbers file’s own time zone, local-save history and sharing mode.
• Numbers from HOUR, MINUTE, SECOND disagree with display: confirm all formulas reference B2 and were refreshed together; do not confuse an AM/PM displayed clock with 24-hour extracted numbers.
• Unexpected text or comparison issue: ensure the deadline and clock cells are true date/time data, not a copied text stamp or imported string that only looks like a date.
• Exact error strings: Apple’s NOW page does not catalogue every error case; native version-specific execution is required before documenting error codes.

Excel and Google Sheets also expose a NOW() formula, but refresh conditions, time-zone choices, and browser/cloud behavior can differ. This Apple-specific guide makes no claim that other spreadsheet products use the exact same file-zone or refresh semantics. Mac, iPhone and iPad local-file cases are described in Apple’s documentation; individual release introduction dates, OS requirements, and custom regional formatting were not established in this run.

In an English-language Numbers document, begin with = and use the comma-separated arguments shown in Apple’s Functions Help. If your device is configured to use a comma as the decimal separator, Apple’s instructions say to separate formula arguments using semicolons. Example: =WEEKDAY(D2;2) rather than =WEEKDAY(D2,2) in such a locale. Quotation marks around a date string do not remove local date-parsing ambiguity; construct examples from numeric DATE(year,month,day) inputs or genuine date-formatted cells instead.

Numbers is table-centred. When the formula is in the same table, D2 identifies that table’s cell; when referring to a different table, select the actual source cell in the formula editor so Numbers inserts the correct table-qualified reference. Do not silently assume Excel’s Sheet1!D2 syntax applies. The expected outputs below use an English Functions Help 15.4 reference path consulted 2026-10-11, not a claim that these functions first appeared in app release 15.4. Apple describes date/time functions in shared Formulas and Functions Help; this research did not establish a minimum Numbers version on macOS, iOS, iPadOS or iCloud. Native verification on each intended app/platform/version is pending.

Testing note: This guide uses documentation-derived examples, not results observed in Apple Numbers.

• Apple Numbers — function documentation
• Apple TODAY
• Apple Functions overview

Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in Apple Numbers.

• No genuine Apple Numbers screenshots are included; this guide does not use mock application images.