Extract Month And Year From Date In Excel

Steps to extract year, month, or day from a date in Excel

In a blank cell, use one of the following formulas based on what you want to extract:

• Year: =YEAR(A1) – extracts the year from the date in cell A1
• Month: =MONTH(A1) – returns the month number (1 to 12)
• Day: =DAY(A1) – returns the day of the month

(Replace A1 with the actual cell reference containing your date)

Result: Excel will return just the year, month, or day from the full date, depending on the formula used.

Tip: You can combine these with TEXT for custom formatting, like =TEXT(A1, "mmm") to display the month as Jan, Feb, etc.