SheetFX
≡
<< Go back to all functions

YEAR

The YEAR function in Google Sheets returns the year specified by a given date.

Function Syntax and Parameters

Syntax: YEAR(date)

Parameters:

  • date: The date from which to extract the year.

Step-by-Step Tutorial

  1. Using YEAR with a specific date:
    • Example: =YEAR("10/31/2021")
    • Result: 2021

Use Cases and Scenarios

  1. Financial Analysis: Extract the year from a transaction date for further analysis.
  2. Project Management: Get the year from a project deadline to calculate the total project duration.
  3. Sales Forecasting: Determine the year of sales data to identify yearly trends.

Related Functions

  • MONTH: Extract the month from a date.
  • DAY: Extract the day from a date.
  • DATE: Create a date by providing the year, month, and day values.

Related Articles