These Excel formulas are pretty self explanatory, but for the sake of explaining it with a real-world example, check out the below calendar.

What if I were to ask you the year of the circled day? You would answer "2018".
The YEAR function returns the year for a given timestamp.
What's the circled day's month? It's in "November", or the "11th" month of the year.
The MONTH function returns the month for a given timestamp.
And lastly, what's the day for the circled date? It's the "15th" day of the month.
The DAY function returns the day in number form for a given timestamp.
Coding with YEAR, MONTH, & DAY
Let's see how this works with the same date above, but in an Excel worksheet.

YEAR coded
Here is the template for the YEAR function:
=YEAR(serial_number)
To determine the year of the given date, we'd code the following...
=YEAR(B1)
...which would result in:

MONTH coded
The template for MONTH is:
=MONTH(serial_number)
So, for our month, we'd type the following:
=MONTH(B1)
This would result in...

DAY coded
Lastly, here's the template for DAY:
=DAY(serial_number)
To determine the day of the month for the timestamp, we'd code this:
=DAY(B1)
This code turns into the following output:

Based on this result, we are able to understand that 43419 represents 11/15/2018.
Practice Problem
What is the MONTH for the following serial number?

Next up, let's learn how to use the SUM and AutoSUM functions!
Excel Cram Kit (Exam 1)
Want to unlock content? Get your Excel Cram Kit (Exam 1) now!
![]() | Apply | PRACTICE EXCEL EXAM 1 (PREVIEW ONLY) |
![]() | Tools | Excel Nerd Notes (Exam 1) (PREVIEW ONLY) |
![]() | Lesson | YEAR, MONTH, DAY![]() |
![]() | Lesson | SUM & AutoSUM![]() |
![]() | Lesson | Relative vs. Absolute Cell References![]() |
![]() | Lesson | RANK![]() |
![]() | Lesson | COUNT![]() |
![]() | Lesson | ROUND![]() |
![]() | Lesson | WEEKDAY vs. WORKDAY (PREVIEW ONLY) |
![]() | Lesson | VLOOKUP (PREVIEW ONLY) |
![]() | Lesson | PMT (PREVIEW ONLY) |
![]() | Lesson | IF (PREVIEW ONLY) |
![]() | Lesson | Percent change (PREVIEW ONLY) |
![]() | Lesson | Excel charts (PREVIEW ONLY) |
![]() | Lesson | Importing text files (PREVIEW ONLY) |

Excel Reviews (Exam 1)
"I bought this Cram Kit the night before my exam, and it helped me tremendously. It provides step-by-step explanations for all the units covered in class."
Matt Lamanna
Oct. 14, 2021