Weekday Abbreviations in Excel & Google Sheets
Download the example workbook
This tutorial will demonstrate how to use Weekday Abbreviations in Excel and Google Sheets.
TEXT, CHOOSE and WEEKDAY Functions
To get the weekday abbreviation from a date, we can use the TEXT function, or we can use the CHOOSE and WEEKDAY functions.
TEXT Function
We can use the TEXT function to obtain the weekday abbreviation.
|
1 |
=TEXT(B3, "ddd") |
In Excel, dates are stored as serial numbers, where each number represents an unique date. The TEXT Function converts a number into a specified text format. Here we specify the format “ddd” to get the day name abbreviation of a date.
CHOOSE and WEEKDAY functions
Alternatively, we can use the CHOOSE and WEEKDAY functions to create a custom weekday abbreviation.
|
1 |
=CHOOSE(WEEKDAY(B3),"S","M","T","W","T","F","S") |
WEEKDAY function
First, we can get the weekday from cell B3
|
1 |
=WEEKDAY(B3) |
CHOOSE function
Next, we can use the CHOOSE function to choose the position of the abbreviation from the listed options, based on the value returned by the weekday function.
|
1 |
=CHOOSE(WEEKDAY(C3),"S","M","T","W","T","F","S") |
Joining these 2 formulas together gives us our result.
|
1 |
=CHOOSE(WEEKDAY(B3),"S","M","T","W","T","F","S") |
Weekday Abbreviations in Google Sheets
All the above examples work the same way in Google Sheets.
