Convert Date into a Month TEXT Formula 

Thank you very much for sharing your knowledge about how to do this. I was trying to do it with the =DAY(B5) option, but it came back a letter (J). I don't know if I had to format the cells or what happened, but this one worked perfect!

Thank you very Helpful😊

Thank you

Thanks

Thanks 🎉

Thx homie

Amazing thanks

Is there a formula for the other way round?

Thnks❤

Great

👍👍

=MONTH(X1) Gah (if you don't like 0, add 1) Don't do text cutting for this, especially fixed text splitting

Kitna Easy h.....

SATH M DATE bhi bata dete sir....date kaise aye

No this is how you write it. Edit : this is an example and I get in trouble for writing it like this but I don’t give a f**k. Here’s how you write it: 7/29/23

kalau data tanggal baru auto ke convert bisa kah ?

14th Aug 2023 h mujh ko 14-8-2023 karna h kese hoga

Or bhi sort dal

hi there! i would like to extract the month information from a date field, eg 30/12/2010, output to be Dec. i usually use text formula or choose month formula. but when i tried these formulas in an excel table, i get #value! :( help!

Great