29. Excel How to extract the month from a date ? How to extract the year from a date ?

---

To extract the year, month or day use the Excel functions YEAR, MONTH or DAY respectively.

Example :

To get the year of the date in cell A2, the formula is :

=YEAR(A2)

To get the month of the date in cell A2, the formula is :

=MONTH(A2)

To get the day of the date in cell A2, the formula is :

=DAY(A2)

---