I want to write a conditional formatting formula that will convert
The rationalization being I have a list of committee meeting dates, which fall on ordered days of the week, not specific days. So I want a date type (as in "second Wednesday") that can be inputted and sorted numerically but read by the user as a string. I already know that the following formula will spit out a "Monday":
and that I can concatenate specific valued strings such as:
to make "2-Monday".
So how can I pose a formula that will interpret a pattern in the form number-hyphen-number to this for arbitrary numeric values (assuming the 3rd character is a number 0-6)?