TODAY

Beginner

Date & Time

Returns the current date as a serial number. Updates automatically when the worksheet is recalculated.

Syntax
=TODAY()
Parameters
Examples
Real-world examples to help you understand how to use TODAY

Get current date

=TODAY()

Returns today's date

Result: 12/29/2025

Calculate age

=YEAR(TODAY())-YEAR(A1)

Calculates age from birthdate in A1

Result: Age in years

Days until deadline

=A1-TODAY()

Calculates days remaining until date in A1

Result: Days remaining

Common Use Cases
  • ✓Display current date
  • ✓Calculate age from birthdate
  • ✓Track days until deadline
  • ✓Date-based conditional formatting
  • ✓Timestamp records
Pro Tips
  • 💡TODAY() has no arguments
  • 💡Updates automatically on file open
  • 💡Returns date only (no time)
  • 💡Use NOW() for date and time
Common Errors
  • ⚠️Adding parentheses with arguments
  • ⚠️Expecting it to stay static (it updates)
  • ⚠️Confusion between TODAY and NOW
Related Formulas
NOWDATEYEARMONTHDAY

Need a Custom TODAY Formula?

Our AI can generate tailored formulas based on your specific needs

Generate Custom Formula