Forum Discussion
Solved
Using Text function to obtain "Months"
Hi Guys,
I am Rahul from India.
I want to obtain "Months" (January, February,--etc) using Text function: =Text((1/13/19,"mmmm")) (US Date format)
I am unable to get the answer;
=>Whereas, I am getting answer for =Text((13-01-2019,"mmmm"))
Note; my Dataset is in following format: (1/13/19 15:00) (US Date format).
Please help me with this error.
Nice approach. Using the same idea:
=INDEX(TEXT(DATE(2022,SEQUENCE(12),1),"mmmm"),LEFT(A1,FIND("/",A1)-1))
If you have a date in a cell, say A1, you can use =TEXT(A1,"mmmm")
If you want to specify a literal date, use the DATE function: =TEXT(DATE(2019,1,13),"mmmm")
- Thanks for you reply Hans,
But how should i convert from format (1/13/19) to a proper Date format, so that i could apply Text function? My complete Dataset consists of improper Date format (1/13/19)!!
Hope i made you clear in understanding.Alternatively, with your improper date in A1 (assuming Excel 2021 or 365):
=LOOKUP(--LEFT(A1, SEARCH("/",A1)-1), SEQUENCE(12), TEXT(DATE(2022,SEQUENCE(12),1),"mmmm"))
