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

YEAR / MONTH / DAY Formula for Date

Extract year, month, or day from a date. Copy-paste ready for Excel, Google Sheets, and Airtable.

=YEAR(A1)
When you need this: When you have transaction dates (A1:A100 = "2024-03-15") and need to group by year or month for reporting.

How it works

  1. 1YEAR extracts just the year (2024).
  2. 2MONTH extracts just the month number (1–12).
  3. 3DAY extracts just the day number (1–31).

Variations

Combine for formatted date string
=MONTH(A1)&"/"&DAY(A1)&"/"&YEAR(A1)
Group transactions by quarter
=ROUNDUP(MONTH(A1)/3,0)

Related Formulas

TODAY / NOW — Get current date or date/timeDateDATEDIF — Calculate difference between two datesDateNETWORKDAYS — Count business days between two datesDateEDATE — Add or subtract months from a dateDate

Need a formula that's not here?

Generate custom formula →