Suppose Cell A2 contains weekday names like Sunday, Monday…..(or Sun, Mon…), then following formula can be used to return the numbers. Sunday will be 1 and Saturday will be 7.
=ROUND(SEARCH(LEFT(A2,2),"SuMoTuWeThFrSa")/2,0)
=MATCH(LEFT(A2,2),{"Su","Mo","Tu","We","Th","Fr","Sa"},0)
If we want to return some other number to weekdays, then formula can be tweaked accordingly. For example, to make Mon = 1 and Sun = 7
=ROUND(SEARCH(LEFT(A2,2),"MoTuWeThFrSaSu")/2,0)
=MATCH(LEFT(A2,2),{"Mo","Tu","We","Th","Fr","Sa","Su"},0)
Below is another formula that will also work. While it is longer than your posted formulas, it makes up for that by only using a single function call.
=LOOKUP(A2,{"Fr*","Mo*","Sa*","Su*","Th*","Tu*","We*"},{6,2,7,1,5,3,4})
This is awesome, as usual from you, Rick!!!