NOW Function in Google Sheets

Get the current date and time using the NOW function.

NOW Function

The NOW function in Google Sheets returns the current date and time.

Syntax

NOW()

Examples

  1. Current Date and Time

Get the current date and time:

=NOW()
  1. Used in Calculations

Calculate the hours since the start of the day:

=(NOW() - DATEVALUE("2024-08-14"))*24

Notes

  • Updates every time the spreadsheet recalculates.
  • Useful for tracking time-sensitive data or logs.
  • TODAY: Returns the current date.