Extracting years and months

Cleaning and preparing data involves manipulating and transforming the data into a form that can be more easily processed during analysis.

Although dates and times are usually continuous values, many analyses only require particular date and time components, such as the year or month. Extracting these components effectively converts the dates and times into discrete values, which can then be grouped or counted, for example.

In this exercise, you'll utilize built-in Google Sheets functions to extract date components from some of the highest grossing films.