Custom weekday abbreviation

How To Create Custom Weekday Abbreviation

Excel offers you with a variety of options when it comes to creating custom weekday abbreviation that makes sense to you. For instance, you may want all the days of the week to be abbreviated by the first letter, first two letter or first three letters. What you need is a CHOOSE and WEEKDAY function to make a formula. This is how the formula looks:

Generic Formula


…..where the “date” is the first date in the column while the “S, M…..” are the abbreviation of the days of a week. WEEKDAY works on values and its reruns are fed to CHOOSE for the abbreviation to be created.


In this example. We are going to show how you can easily generate a custom weekday abbreviation of your choice. We will focus on the last week of December 2018. Check it out.

Figure 1. Example 1 of CHOOSE/WEEKDAY Formula

From the screenshot, the formula in C6 is:


How CHOOSE/WEEKDAY Formula Works:

Let’s work it from inside. The first function to be evaluated from the inside is the WEEKDAY which takes a returns a number between 1 & 7 from the dates. NOTE that Sunday by default always corresponds to number one while 7 is number seven.

With that, the CHOOSE function works on WEEKDAY returns by mapping the numbers to values. That’s how custom weekday abbreviation is generated.


Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment