Date Formats - Month Name/Text from Date

simon_ritchie
Certified Master Anaplanner

Date Formats - Month Name/Text from Date

Hi, Does anyone know of a function that I can use to format a date in a specific manner. Bringing in month names instead of numbers. e.g. From 1/1/2014 I want 'Jan 14' as text In excel I would the text function - TEXT(*date*,"MMM YY") Thanks, Simon

1 ACCEPTED SOLUTION

Accepted Solutions
PrevContributor
Previous Contributor

RE: Date Formats - Month Name/Text from Date

Hi Simon, You can convert a date to the format you described by adding a list with Jan, Feb, etc. and assigning codes 1-12. Then, you can add the line items and formulas shown below to get the month names followed by the year. Let me know if you have any questions! Thanks, John

View solution in original post

5 REPLIES 5
PrevContributor
Previous Contributor

RE: Date Formats - Month Name/Text from Date

Hi Simon, You can convert a date to the format you described by adding a list with Jan, Feb, etc. and assigning codes 1-12. Then, you can add the line items and formulas shown below to get the month names followed by the year. Let me know if you have any questions! Thanks, John

View solution in original post

Andrew_Paston
New Contributor

Re: RE: Date Formats - Month Name/Text from Date

Hi John

 

I know this is very old post but i was interested in this solution and cant find the formulas you mentioned below? Have they dissapeared?

 

Cheers

Andrew

MNHHS
New Contributor

Re: RE: Date Formats - Month Name/Text from Date

John

 

I can't see any formulas

 

Chris

pooja.joshi7
New Contributor

Re: RE: Date Formats - Month Name/Text from Date

Hi John,

Greetings for the day!!

I can't see formulas and  screenshots posted by you.

Can you please check once.

 

Thanks

Pooja

simon_ritchie
Certified Master Anaplanner

RE: Date Formats - Month Name/Text from Date

Hi John, Thanks for the suggestion. Screenshots are great. It's a tidy little solution that will suit my purposes very nicely. :) Thanks, Simon