How to do Custom Abbreviations of Weekdays.

By default, Excel provides abbreviations of weekdays as Sun for Sunday, Mon for Monday, Tue for Tuesday, etc. But what if you want to abbreviate the names of weekdays by yourself? How do you abbreviate Su fo Sunday, Mo for Monday, Tu for Tuesday, etc. ? You can this in Excel using a simple formula.

Generic Formula for custom weekday abbreviations:




Date: This a valid Excel Date. It can be hardcoded or a reference of a cell that contains data.

Let's see this formula in action.

Example: Get Custom Abbreviated Day Name  of Dates in Excel

Here I have some dates in a range. I want to get weekday names in abbreviated form. The abbreviation contains only the first two letters of week name.

To abbreviate weekdays, we use the above the mentioned formula. Here the date is in A3. Write the below formula in B3 and drag it down.




And this returns the result as:

If you want the excel abbreviated day names, follow this link.

How does it work?

The method is simple. The WEEKDAY function returns the day number of the given date in its respective week. The CHOOSE function takes this number as an argument and returns the text from the rest of the arguments.

In cell B3, WEEKDAY function returns 4 as Wednesday is the fourth day in a week. Now CHOOSE function takes 4 as an argument and returns the 4th option from the arguments which "We".

In the other method, the SWITCH function takes the argument from WEEKDAY function as 4. Then it looks for 4 in the arguments and returns the corresponding text, which is "We".

So yeah guys, this how you can abbreviate the weekday names to your choice. You can even give them names that no other person can understand, like secret codes (I wonder what will be the need for this).

If you have any doubts regarding this topic or any other topic in Excel/VBA, ask in the comments section below.

Related Articles:

Get day name from Date in Excel| In Excel, we can find the day name from Date. There are 7 days in a week named Monday, Tuesday, Wednesday, Thursday, Friday, Saturday and Sunday.


How to Convert date to textExcel stores date with corresponding serial number. While calculating dates with numbers it gives a result, so we will convert Date into Text to avoid the above mistake.

Popular Articles:


How to use Excel VLOOKUP Function| This is one of the most used and popular functions of excel that is used to lookup value from different ranges and sheets. 

How to use the Excel COUNTIF Function| Count values with conditions using this amazing function. You don't need to filter your data to count specific value. Countif function is essential to prepare your dashboard.




Leave a Reply


Terms and Conditions of use
