Text
Convert Y/N schedule columns into days-of-week text ("Mon, Wed, Fri")
Turn seven Y/N delivery or availability flags into a weekday label list and a matching count.
Summarize wide Y/N availability grids into human-readable schedule tags!
These columns contain text flags Y and N, not Boolean TRUE/FALSE values. Require seven recognized flags and seven nonempty headers so a blank or mistyped flag cannot silently become a day off.
Output follows column order and uses the header text exactly as supplied. It does not translate weekdays, resolve dates, apply time zones or schedule an actual event. Keep a consistent weekday legend for your audience.
Lowercase y/n follows the case-insensitive comparisons used here. Spaces are not trimmed; a value such as Y followed by a space is invalid. The zero-match text is No Scheduled Days, not a substitute for missing data.
| Route / Shift | Mon–Fri Flags | Sat–Sun Flags | Generated Schedule Label |
|---|---|---|---|
| Route-North (Row 2) | Y, N, Y, N, Y | N, N | "Mon, Wed, Fri" (3 days/wk) |
| Route-Weekend (Row 3) | N, N, N, N, N | Y, Y | "Sat, Sun" (2 days/wk) |
| Suspended Route | N, N, N, N, N | N, N | "No Scheduled Days" (0 days/wk) |
Convert a 7-column Y/N row into comma-separated weekday abbreviations
FILTER's third argument ("No Scheduled Days") prevents #CALC! when all seven columns are "N".
=IF(OR(COUNTBLANK(B1:H1)>0,COUNTIF(B2:H2,"Y")+COUNTIF(B2:H2,"N")<>7),"Invalid inputs",TEXTJOIN(", ", TRUE, FILTER($B$1:$H$1, B2:H2 = "Y", "No Scheduled Days")))Count scheduled days per week
Tallies weekly frequency alongside the text schedule string.
=IF(OR(COUNTBLANK(B1:H1)>0,COUNTIF(B2:H2,"Y")+COUNTIF(B2:H2,"N")<>7),"Invalid inputs",COUNTIF(B2:H2, "Y"))Try the example
Use the original values or change them to test your understanding.