Weekday Abbreviations in Excel & Google Sheets

This tutorial will demonstrate how to use Weekday Abbreviations in Excel and Google Sheets.

weekday abbreviations Main


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.

weekday abbreviations 01

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.

AutoMacro - VBA Code Generator

CHOOSE and WEEKDAY functions

Alternatively, we can use the CHOOSE and WEEKDAY functions to create a custom weekday abbreviation.


WEEKDAY function

First, we can get the weekday from cell 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.


Joining these 2 formulas together gives us our result.


Weekday Abbreviations in Google Sheets

All the above examples work the same way in Google Sheets.

weekday abbreviations Google




Excel Practice Worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!