Browse

NOW Function (LibreOffice Calc)

Date & Time Beginner LibreOffice Calc LibreOffice 3.0

The NOW function returns the current date and time as a dynamic value that updates whenever the spreadsheet recalculates. It is essential for dashboards, timestamps, scheduling, and real-time calculations.

The **NOW** function returns the **current date and time** as a dynamic value that updates whenever the spreadsheet recalculates. It is essential for dashboards, timestamps, scheduling systems, and any workflow that depends on real-time information.

What the NOW Function Does

  • Returns the current date and time
  • Updates on recalculation
  • Returns a serial number (date + fractional day)
  • Can be formatted as date, time, or both
  • Works in all major spreadsheet applications

It is designed to be dynamic, real-time, and ideal for dashboards and automation.

Syntax

NOW()

Arguments

  • None.

Basic Examples

Current date and time

=NOW()

Format as date only

=INT(NOW())

Format as time only

=NOW() - INT(NOW())

Use NOW in a label

="Report generated on: " & TEXT(NOW(); "YYYY-MM-DD HH:MM:SS")

Advanced Examples

Calculate hours since a timestamp

=(NOW() - A1) * 24

Calculate minutes since a timestamp

=(NOW() - A1) * 1440

Calculate seconds since a timestamp

=(NOW() - A1) * 86400

Auto-updating age in days

=NOW() - A1

Auto-updating age in years

=YEAR(NOW()) - YEAR(A1) - (DATE(YEAR(NOW());MONTH(A1);DAY(A1)) > NOW())

Timestamp difference between two NOW snapshots

=(B1 - A1) * 24

Dynamic countdown to a deadline

=A1 - NOW()

Dynamic “time since last update”

=NOW() - A1

Convert NOW to ISO timestamp

=TEXT(NOW(); "YYYY-MM-DD\"T\"HH:MM:SS")

Use NOW in a dashboard header

="Last updated: " & TEXT(NOW(); "YYYY-MM-DD HH:MM")

Recalculation Behavior

NOW updates when:

  • The sheet recalculates
  • You edit any cell
  • You press F9
  • You reopen the file

NOW does not update:

  • Every second
  • In real-time without recalculation
  • When the file is closed

To freeze a timestamp:

=NOW()

Then copy → Paste Special → Values Only.

Edge Cases and Behavior Details

NOW returns a number, not text

NOW includes both date and time

NOW uses system clock

NOW ignores locale formatting

Formatting is applied separately.

NOW recalculates based on spreadsheet settings

(Manual vs automatic recalculation)

NOW of an error → error propagates

Common Errors and Fixes

NOW displays as a number (e.g., 45234.75)

Cause:

  • Cell not formatted as date/time

Fix:

  • Apply a date/time format

NOW not updating

Cause:

  • Manual recalculation enabled

Fix:

  • Press F9 or enable automatic recalculation

Wrong time zone

Cause:

  • System clock or OS time zone incorrect

Fix:

  • Adjust OS settings

Best Practices

  • Use NOW for dynamic dashboards
  • Use TODAY when you only need the date
  • Use INT(NOW()) to strip time
  • Use NOW() - A1 for elapsed time
  • Freeze timestamps with Paste Special → Values
  • Use TEXT(NOW()) for readable labels
NOW is your real-time heartbeat — perfect for dashboards, logs, timestamps, and any workflow that needs to stay current every time the sheet recalculates.
  • Use TODAY for date-only
  • Use TIME for constructing times
  • Use DATE for constructing dates
  • Use HOUR, MINUTE, SECOND for extraction
  • Use VALUE to convert text timestamps

By mastering NOW and its companion functions, you can build powerful, real-time, and fully dynamic workflows in LibreOffice Calc.

Reproducible example (tested in LibreOffice Calc)

This standalone example was calculated in LibreOffice Calc 25.2.3.2 and matched the expected value. It is a practical cross-check of one usage, not proof that every example elsewhere on this page is correct.

=YEAR(NOW())

Expected result: The calendar year at calculation time; this changes over time.

Read the current timestamp, then extract its year (changes over time).

If the result differs, check the referenced cells, argument separators and number formatting. For more information, consult the LibreOffice Calc official help.