Year on a Cell

Learn how to extract just the year from a date in a cell using a specific formula combination in Google Sheets.

What if I want a year in a cell? Just the year. Not the date, not the day, not the month, only the year. There's a formula for that. And actually, there's a formula combination.

Better Sheets

Stop guessing your way through Google Sheets. Pick up beginner tutorials when you're stuck on the basics. And study advanced workflows when you're ready to automate. Practical lessons, zero fluff.

Get Started Now

Explore

Academy

Tools

Add ons