Excel kılavuzu

How to Extract Month and Year from a Date in Excel

Extracting specific time components from a date is essential for data analysis and reporting. You can achieve this easily using the MONTH, YEAR, or TEXT functions.

Bunun yerine yapay zekâ ile yap

Adım adım

1
Prepare your data
Ensure your dates are stored in a standard date format in a column, such as column A.
2
Use the MONTH and YEAR functions
In a new cell, enter '=MONTH(A2)' to get the month number or '=YEAR(A2)' to get the year.
3
Use the TEXT function for custom formatting
To get the month name, use '=TEXT(A2, "mmmm")' or for a combined format, use '=TEXT(A2, "mmmm-yyyy")'.
4
Apply to the rest of the column
Double-click the fill handle at the bottom-right corner of the cell to apply the formula to the entire column.

=TEXT(A2, "mmmm yyyy")

İpuçları

The TEXT function converts the date into a text string, which is perfect for labels but cannot be used for date-based calculations.

SSS

Why does my MONTH function return a number instead of a name?

The MONTH function is designed to return the month index (1-12). Use the TEXT function with the "mmmm" format code if you need the full month name.