 Stop manually converting a date to day of week or month name and instead use this simple Excel formula. Start your formula with the equal sign and then write the word text. Next, select your cell containing the date value and then within quotations, we're going to do four lowercase ds to identify we want the long form day name and then copy that down the entire range. Next, for month, we'll be using exactly the same formula. However, this time in quotations we'll be doing a lowercase m four times to identify the long form month name. If however you want short form for both the day of the week and the month, all you need to do is enter three characters rather than four. Please don't forget to hit that like button if you enjoyed this video.