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:
…..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.