YEAR function for Sheets

Help Center AI Assistant is now available

Got questions about Lark? Use our AI chat to find the answers.

Click and hold to drag

Got It

1 min read

I. Intro

You can use the YEAR function to obtain the year of a date, expressed as an integer.

II. About the function

In a cell, enter =YEAR("2021-6-30") or =YEAR("2021/6/30"). Since the year is 2021, it will return 2021.

Set the cell format as either General or Number to ensure the correct results are displayed.

III. Steps

Select a cell and click Formula in the toolbar, select All functions, and search for YEAR. You can also directly enter =YEAR in a cell.

Enter the parameters (date value). The year, month, and day can be separated by either a hyphen (-) or a slash (/).

250px|700px|reset