{"id":3366,"date":"2021-05-26T00:53:40","date_gmt":"2021-05-26T07:53:40","guid":{"rendered":"https:\/\/SUMMALAI.COM\/?p=3366"},"modified":"2021-05-26T00:54:25","modified_gmt":"2021-05-26T07:54:25","slug":"hot-convert-dates-to-weekday-month-name-with-text-function-in-excel","status":"publish","type":"post","link":"https:\/\/SUMMALAI.COM\/?p=3366","title":{"rendered":"Hot Do You Convert Dates To Weekday\/Month Name With TEXT Function in Excel"},"content":{"rendered":"\n

Microsoft Excel’s TEXT<\/strong> function can help you to convert a date to its corresponding month name or weekday name easily.<\/p>\n\n\n\n

TEXT(A2,”dddd”)<\/em><\/p>\n\n\n\n

TEXT(A2,”ddd”)<\/em><\/p>\n\n\n\n

TEXT(A2,”mmmm”)<\/em><\/p>\n\n\n\n

TEXT(A2,”mmm”)<\/em><\/p>\n\n\n\n

In a blank cell, please enter this formula =TEXT(A2,”mmmm”)<\/strong>, in this case in cell C2. , and press the Enter<\/strong> key. And then drag this cell’s AutoFill handle to the range as you need.<\/p>\n\n\n\n

And the date have been converted to month name. See screenshot:<\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

Note<\/strong>: You can change the “mmmm” to other format code according to above table. For example, you can also convert a date to the weekday name with the formula =TEXT(A2,”dddd”)<\/em>.<\/p>\n","protected":false},"excerpt":{"rendered":"

Microsoft Excel’s TEXT function can help you to convert a date to its corresponding month name or weekday name easily. TEXT(A2,”dddd”) TEXT(A2,”ddd”) TEXT(A2,”mmmm”) TEXT(A2,”mmm”) In a blank cell, please enter this formula =TEXT(A2,”mmmm”), in this case in cell C2. , and press the Enter key. And then drag this cell’s AutoFill handle to the range as you need. And the Read More<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[10,18],"tags":[747,748,746],"class_list":["post-3366","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-microsoft-office","tag-month-name-in-excel","tag-text-function","tag-weekday-name-excel"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t