Summary

In this challenge, the goal is to end up with a text string like "MWF" for Monday, Wednesday, Friday. The problem is that the weekdays are input as yes/no abbreviations like "NYNYNYN" for "MWF". What formula will translate the "N" and "Y" to weekday abbreviations?

A long-time reader sent me an interesting problem this past week. The goal is to end up with a text string like "MWF" for Monday, Wednesday, Friday. The problem is that the weekdays are input as yes/no abbreviations like "NYNYNYN" for "MWF".

Challenge

What formula will translate the "N" and "Y" to weekday abbreviations as shown in the screenshot above?

The workbook is attached below. Post your answer in the comments.

Extra points for style and elegance, but workhorse solutions are fine, too :)

Assumptions

  1. All inputs are 7 characters and contain only "Y" or "N"
  2. Days are mapped Sunday through Saturday, SMTWTFS.

Support Exceljet

Many websites (including Exceljet) have lost over half their traffic in the past year because of the crushing impact of AI on web searches. Exceljet is still at it, publishing free content each week. If you find Exceljet helpful, you can support the site and go ad-free with the Exceljet Lifetime Pass. One payment, no subscription, and ads are gone forever. Plus, you get our Excel Shortcuts video course as a thank you.

Get the Lifetime Pass