How to extract year and month from a date and combine them into a text

**billj** · 06-02-2017, 08:52 AM

Hi everyone,

I have tried to extract year and month and combine them. For a date such as 31/05/2017, I want to get the output as 2017_05. How can do that?

Thank you.

**63falcondude** · 06-02-2017, 08:54 AM

With the date in A1, try

=YEAR(A1)&"_"&MONTH(A1)

or

=TEXT(A1,"yyyy\_mm")

This will change the date to Text format.

You can also change the formatting of A1 to Custom yyyy\_mm and keep the value as an Excel recognized date.

**billj** · 06-02-2017, 09:00 AM

Sorry, I need VBA version. My mistake. I should have put this message in the VBA section.

**Phuocam** · 06-02-2017, 09:15 AM

MDate = Format(Mydate, "yyyy\_mm")

**billj** · 06-02-2017, 09:24 AM

Thank you so much, Phuocam. It is very useful.

How to extract year and month from a date and combine them into a text

LinkBack

Thread Tools

Rate This Thread

Display

How to extract year and month from a date and combine them into a text

Re: How to extract year and month from a date and combine them into a text

Re: How to extract year and month from a date and combine them into a text

Re: How to extract year and month from a date and combine them into a text

Re: How to extract year and month from a date and combine them into a text

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Extract Year, Month, Day from date

Extract Year, Month, Day from date

[SOLVED] Extract 2 corresponding fields by Date/Month/Year selection

[SOLVED] Extract Day, Month and Year from a text box (user input) date value

[SOLVED] Combine date (month) and text and still be able to add a month to next column

[SOLVED] Extract Year or Month only from a cell with date and time

[SOLVED] Extract Text from String then Convert to a Date (Month/Year)

Bookmarks

Bookmarks

Posting Permissions