Working with Dates in Google Sheets: How to Use the YEAR Function

Google Sheets is a powerful tool for organizing and analyzing data, and one of the most useful functions for working with dates is the YEAR function. This function allows you to extract the year from a date or a timestamp, which can be very useful for sorting and filtering data. In this article, we will show you how to use the YEAR function in Google Sheets, along with some examples of how it can be used.

The syntax for the YEAR function is very simple. You simply enter the function, followed by the date or timestamp that you want to extract the year from, in parentheses. For example, if you have a date in cell A1, you would enter the following formula in another cell: =YEAR(A1)

This will return the year of the date in cell A1. You can also use the YEAR function to extract the year from a timestamp, which is a date and time value. For example, if you have a timestamp in cell A2, you would enter the following formula: =YEAR(A2)

The function can also be combined with other functions for more advanced use cases. For example, you can use the YEAR function in combination with the IF function to create a conditional statement based on the year of a date. For example, you can use the following formula to check if a date is in the current year: =IF(YEAR(A1)=YEAR(TODAY()), "Current Year", "Not Current Year")