Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Number and Text Filters Examples in Excel
  • Excel Frequency Function Example
  • Excel Bar Chart
  • How to calculate average last N values in a table in Excel
  • Working With Tables in Excel

References

  • How to reference named range different sheet in Excel
  • How to use Excel OFFSET function
  • How to get address of first cell in range in Excel
  • How to use Excel MATCH Function
  • How to use Excel COLUMN Function

Data Validations

  • Excel Data validation number multiple 100
  • Data validation must not exist in list
  • Excel Data validation whole percentage only
  • Excel Data validation allow weekday only
  • Excel Data validation unique values only

Custom weekday abbreviation in Excel

by

This tutorial shows how to create custom weekday abbreviation in Excel using example below.

To create a custom weekday abbreviation, you can use a formula based on the CHOOSE and WEEKDAY functions. With this approach, you can generate a custom one-letter abbreviation, two-letter abbreviation, or any weekday that makes sense in your particular situation.

Worked Example:   WEEKDAY function: Description, Usage, Syntax, Examples and Explanation

Formula

=CHOOSE(WEEKDAY(date),"S","M","T","W","T","F","S")

Explanation

In the example shown, the formula in C5 is:

=CHOOSE(WEEKDAY(B5),"S","M","T","W","T","F","S")

How this formula works

Working from the inside-out, the WEEKDAY function takes a date and returns a number between 1 and 7. With default settings, the number 1 corresponds to Sunday and the number 7 corresponds to Saturday.

Worked Example:   Map inputs to arbitrary values in Excel

The CHOOSE function simply maps numbers to values. The first argument is the number to map, and subsequent arguments represent associated values.

In this case, 7 values have been provided in the order required to work with WEEKDAY’s Sunday through Saturday scheme.

Worked Example:   Get first Monday before any date in Excel

With a date from column B, WEEKDAY returns a number which is fed to the CHOOSE function. CHOOSE returns the value at that position in the list of abbreviations.

Post navigation

Previous Post:

Create date range from two dates in Excel

Next Post:

Convert text date dd/mm/yy to mm/dd/yy in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • FALSE function: Description, Usage, Syntax, Examples and Explanation
  • How to return blank in place of #DIV/0! error in Excel
  • How to use Excel TRUE Function
  • IFS function: Description, Usage, Syntax, Examples and Explanation
  • SWITCH function example in Excel

Date Time

  • Get age from birthday in Excel
  • Count day of week between dates in Excel
  • How to join date and text together in Excel
  • Get days before a date in Excel
  • Get last weekday in month in Excel

Grouping

  • Group times into unequal buckets in Excel
  • How to randomly assign people to groups in Excel
  • Group numbers with VLOOKUP in Excel
  • How to randomly assign data to groups in Excel
  • Map inputs to arbitrary values in Excel

General

  • How to calculate decrease by percentage in Excel
  • How to Insert Cells, Row and Rows in Excel
  • How to calculate percent of goal in Excel
  • List worksheet index numbers in Excel
  • How to calculate percentage discount in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning