Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • VLOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel TRANSPOSE Function
  • Count unique text values with criteria
  • How to get first row number in range in Excel
  • How to use Excel OFFSET function

Data Analysis Examples

  • How to combine 2 or more chart types in a single chart in Excel
  • Everything about Charts in Excel
  • Subtotal function in Excel
  • Get column index in Excel Table
  • Chart Axes in Excel

Data Validation Examples

  • Data validation must not exist in list
  • How To Create Drop-down List in Excel
  • Excel Data validation don’t exceed total
  • Prevent invalid data entering in specific cells
  • Excel Data validation must not contain

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:   How to calculate nth day of week in month in Excel

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:   Count dates by day of week 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:   OR function Examples 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
  • How to extract domain name from URL in Excel
  • How to check if cell contains number in Excel
  • PHONETIC function: Description, Usage, Syntax, Examples and Explanation
  • How to check if cell contains one of many things in Excel
  • How to count specific characters in a range in Excel
  • How to calculate Day of the Year in Excel
  • How to get same date next year or previous year in Excel
  • Get week number from date in Excel
  • Get last working day in month in Excel
  • Convert date to month and year in Excel
  • Example of Future value of annuity in Excel
  • CUMIPMT function: Description, Usage, Syntax, Examples and Explanation
  • MIRR function: Description, Usage, Syntax, Examples and Explanation
  • INTRATE function: Description, Usage, Syntax, Examples and Explanation
  • COUPDAYSNC function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2022 xlsoffice . All Right Reserved. | Teal Smiles