Forum Discussion
DATE to MONTH problem (TEXT function)
Hello everyone,
I want to convert dates to months in the MONTH column. I tried the TEXT function, it worked for some dates but the other dates were unable to be converted. Some dates, such as "." or "/" differ, but how can I resolve this issue? Thank you.
- Worked for me! Thank you!
- DATE: 4.1.2019 -> MONTH: =TEXT(B2;"mmmm") -> RESULT: November - This is ok
DATE: 6/25/19 -> MONTH: =TEXT(B3;"mmmm") -> RESULT: 6/25/19 - Not June.
Why is that?
The formula you sent did not work.See if this formula works for you:
=TEXT(IF(ISTEXT(B2),DATE(2000,LEFT(B2,FIND("/",B2)-1),1),B2),"mmmm")
