Free YEAR Formula Generator

Returns the year of a date, an integer in the range 1900-9999.

Generated Formula
=YEAR(date)

Learning Resources

Want to master Excel? Check out this Top-Rated Course.

Related Formulas

DATEDIFNOWTODAYNETWORKDAYSMONTH

Want to become an Excel Pro?

Stop searching for formulas. Master Excel in 30 days with this top-rated course.

Learn More