I have shipment names with the days of the week they ship abbreviated inside them. For instance Shipment1_M_WThF. This shipment goes out on Mondays, Wednesdays, Thursdays, and Fridays. I also have Shipment2_Fr-Su, which goes out on Friday, Saturday, and Sunday.
I also have a shipment tracker spreadsheet with the day the item actually went out. I have the date that I converted to the day of week name. For instance, 12/2/2022 is a Friday. How do I match the partial string (M,Tu,W,Thu,F,Sat,Sun) in the first spreadsheet to the full day name (Friday) in the other spreadsheet only if the shipment ID is the same?
I also have a shipment tracker spreadsheet with the day the item actually went out. I have the date that I converted to the day of week name. For instance, 12/2/2022 is a Friday. How do I match the partial string (M,Tu,W,Thu,F,Sat,Sun) in the first spreadsheet to the full day name (Friday) in the other spreadsheet only if the shipment ID is the same?
