Date Formats - Month Name/Text from Date

simon_ritchie
simon_ritchie
in Modeling

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

Tagged:

Best Answer

  • PrevContributor
    PrevContributor
    Answer ✓
    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

Comments

  • simon_ritchie
    simon_ritchie
    Hi John,

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

    Thanks,
    Simon
  • Andrew_Paston
    Andrew_Paston

    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
    MNHHS

    John

     

    I can't see any formulas

     

    Chris

  • pooja.joshi7
    pooja.joshi7

    Hi John,

    Greetings for the day!!

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

    Can you please check once.

     

    Thanks

    Pooja

  • ddevine
    ddevine

    Hi

    This is my solution to output "Feb 21" for example:

     

    Date format: First Date of Period = START()

    Output for February is 1/2/2021

     

    Time format (month): Month Period = PERIOD(First Date of Period)

    Output is "Feb 21".

     

    Regards,

    Declan

     

Categories