Better Sheets

How to Use YEAR() in Google Sheets

Description

Returns the year specified by a given date.

How To Actually Use YEAR() in Sheets

YEAR(date)

Try YEAR yourself

In cell B1, use the YEAR() formula to extract the year from the date in cell A1. The correct answer must return a four-digit year.

Your formula

Hints (2)

Locale Separator ,

Official Docs

3 Better Sheets Tutorials

Can I Automatically Rename a Sheet based on a Date?

Change the title of a spreadsheet from within a cell in the spreadsheet.

Intermediate

DAY() MONTH() TODAY() YEAR()

Get Sheets Wrapped 2024 | Your Year in Google Sheets

Get this free review of your Google Sheets in 2024.
https://bettersheets.co/sheetswrapped

Beginner

DATEDIF() TODAY() YEAR()

Free Education Expense Template

Get this free education funding template I use myself. I use it and enjoy it. Thought you would too.

FV() JOIN() SUMIF() TODAY() YEAR()

Transcript-matched member videos for YEAR(). Click through to watch.

Browse more tutorials

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

Calculate ROAS in Google Sheets

Calculate Return on Ad Spend with a formula combination. Bonus: create a...

Intermediate

CONCATENATE() ROUND()

Google Sheet Basics - The Absolute Basics

Let's start at the basics of Google Sheets. Where every beginner spreads...

Beginner

Learn Google Sheet Formulas The Hard Way

One weird way to learn more about what Google Sheets can do. https://bet...

Unlock these tutorials

Learn more about the YEAR() formula:

Generate a YEAR() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses YEAR(). 2 free AI generations, no signup. Members get unlimited use.

Generate a YEAR() formula