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
Thanks for the suggestion. Screenshots are great.
It's a tidy little solution that will suit my purposes very nicely.
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?
I can't see any formulas
Greetings for the day!!
I can't see formulas and screenshots posted by you.
Can you please check once.
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".