YEAR

Google-Sheets

Definition

Extracts the year from a date.

Example

=YEAR("2025-06-02") returns 2025.

Stop Juggling Dashboards. Start Growing Get your data flowing today, free plan available.