Register

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

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
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