Convert Date into a Month TEXT Formula

preview_player
Показать описание
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!

anamarcelamena
Автор

Is there a formula for the other way round?

charalamposkounes
Автор

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 🙏🙏

krishnathetchina
Автор

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

tutacat
Автор

kalau data tanggal baru auto ke convert bisa kah ?

muhammadbaiduri
Автор

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

monikanarang
Автор

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

MonikaSharma-kwzp
Автор

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

Travel_Freak
Автор

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!

czhcdvw