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...
Nice approach. Using the same idea:
=INDEX(TEXT(DATE(2022,SEQUENCE(12),1),"mmmm"),LEFT(A1,FIND("/",A1)-1))
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.
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"))Nice approach. Using the same idea:
=INDEX(TEXT(DATE(2022,SEQUENCE(12),1),"mmmm"),LEFT(A1,FIND("/",A1)-1))- Even better HansVogelaar
- Perfect Guys, this is much easy approach. Thanks for your support HansVogelaar , Lorenzo