I have a basic shipping excel spreadsheet, in column A I have dates, and in column B I would like it to show when I can ship as there's a processing hold.
So if the day of the week from column A is Saturday, Sunday, Monday or Tuesday then it displays Friday, but if its Wednesday, Thursday or Friday it would display Wednesday.
I know this should be simple but i just can't get the IF query to work. Please help.
Thanks in advance.