From the course: Google Sheets: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Find the parts of a date

Find the parts of a date - Google Sheets Tutorial

From the course: Google Sheets: Advanced Formulas and Functions

Start my 1-month free trial

Find the parts of a date

“

- When you analyze business data, such as sales, the month, day, or year of the event matters. If you have a full date, such as March 9, 2018, you can pull out parts of the date, using the day, month, and year functions. I'll show you how to do that in this movie. This workbook contains a single worksheet and in it, I have a number of order dates, from the first three months of the year 2018. What I'd like to do for my own analytical purposes is to pull out the year, month, and day of each order, so that I can analyze it using other algorithms. There are specific functions that you can use it to pull out that information from a full date and as it happens, they are the names of the data you are trying to pull out, the year, month, and day. So let me show you how to find the year for the value in A2. In cell B2, I'll type an equal sign to start my formula and then the function year, followed by a left parenthesis, and then A2, which is the cell that contains my value. I can see the…

Contents