YEAR Function Examples – Excel, VBA, & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on February 9, 2023
Download Example Workbook

Download the example workbook

This tutorial demonstrates how to use the YEAR Function in Excel and Google Sheets to return the year from a date.

YEAR Formula Main


YEAR Examples

The YEAR Function returns the year of a date:



YEAR and DATE Functions

Using the DATE and YEAR Functions you can build a new date using the same year as the original date:


Year date

First Day of Year

Using the same logic as the previous example, we can use the YEAR and DATE functions to reference the first day of the year:


First day of the year

YEAR in Google Sheets

The YEAR Function works exactly the same in Google Sheets as in Excel:

YEAR Google Sheet

YEAR Examples in VBA

You can also use the YEAR function in VBA. Type:


For the function arguments (serial_number, etc.), you can either enter them directly into the function, or define variables to use instead.

AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to List of Excel Functions