ChatGPT gives awesome ways to think about things. =TEXT(A221, "dddd") is a ridiculously easy way to get the day name from any date. Ive always used an annoying version of vlookup(weekday(date),table_of_days))...  give it a try :-)