{"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":[],"_links":{"self":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3366","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3366"}],"version-history":[{"count":2,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3366\/revisions"}],"predecessor-version":[{"id":3368,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3366\/revisions\/3368"}],"wp:attachment":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3366"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3366"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3366"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}