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😊

Is there a formula for the other way round?

Thx homie

Thanks 🎉

Amazing thanks

Thank you

Thanks

Thnks❤

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

Sun 01 may-24 Mon 02 may -24 Tue 03 may - 24 Wed 04 may - 24 Thu 05 may - 24 Fri 06 may -24 Sat 07 may -24 Sun 08 may-24. Same typeing One month attance tricks available sir Tell me please help me 🙏🙏

👍👍

kalau data tanggal baru auto ke convert bisa kah ?

Great

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

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

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

Kitna Easy h.....

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!

Or bhi sort dal

Great