Trying to do a thing with Excel
Anyone know if there's a simpler way for Excel to interpret weekday-as-text input as values that can be manipulated than using LOOKUP? At the moment I'm using this monstrosity:
=IF(K2>=1,LOOKUP(F2,{"Friday",7;"Monday",3;"Saturday",1;"Sunday",2;"Thursday",6;"Tuesday",4;"Wednesday",5})+1,IF(K2<0,LOOKUP(F2,{"Friday",7;"Monday",3;"Saturday",1;"Sunday",2;"Thursday",6;"Tuesday",4;"Wednesday",5})-1,F2))
I'm using 1904 date format (in which Excel interprets "1" as Saturday January 2nd, 1904) so with my output column set to custom format dddd this formula allows me to display either the previous, same, or following weekday as in column F based on the data in column K.
But I feel like there must be a prettier way to do this?