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 ...
See if this formula works for you:
=TEXT(IF(ISTEXT(B2),DATE(2000,LEFT(B2,FIND("/",B2)-1),1),B2),"mmmm")
great help!!!!! thanks a lot!
