Extract Month and Year from Date in Excel

This post will guide you how to extract month and year from a date in excel. How do I get month and year from date cells  with a formula in Excel. How to convert date to month and year in Excel.

Extract Month and Year from Date


If you want to extract month and year from a date in Cell, you can use a formula based on the TEXT function.
Assuming that you have a list of data in range B1:B4 that contain dates, and you want to convert the normal excel date into year and month format (yyyymm), How to achieve it. You can use the following format:

=TEXT(B1,"yyyymm")

Type this formula into a blank cell and then press Enter key in your keyboard. and drag the AutoFill Handle over other cells to apply this formul.

extract month and year from date1

This formula will get a date with the year and month only from the orignial date in Cells.

If you only want to extract month from a date, and you can use the following formula:

=TEXT(B1,"mmm")

extract month and year from date2

If you want to convert date to year format only, you can use the following formula:

=TEXT(B1,"yyyy")

  extract month and year from date3

Related Functions


  • Excel Text function
    The Excel TEXT function converts a numeric value into text string with a specified format. The TEXT function is a build-in function in Microsoft Excel and it is categorized as a Text Function. The syntax of the TEXT function is as below: = TEXT (value, Format code)…

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar