fx =TODAY()ABCProject A2026-01-1573 daysProject B2026-02-2037 daysProject C2025-12-01118 days
📅 Date

TODAY / NOW Formula for Date

Get current date or date/time. Copy-paste ready for Excel, Google Sheets, and Airtable.

=TODAY()
When you need this: When you need to calculate an employee tenure automatically — create today's date with TODAY() and subtract hire date (A1).

How it works

  1. 1TODAY() returns today's date (updates daily, no input needed).
  2. 2NOW() returns current date AND time.
  3. 3Use either in calculations: =TODAY()-A1 gives days since date in A1.

Variations

Calculate days until deadline
=C1-TODAY()
Get current year
=YEAR(TODAY())

Related Formulas

DATEDIF — Calculate difference between two datesDateNETWORKDAYS — Count business days between two datesDateEDATE — Add or subtract months from a dateDateYEAR / MONTH / DAY — Extract year, month, or day from a dateDate

Need a formula that's not here?

Generate custom formula →