I need a formula that will always return the next specified day of the week.
IF(A1="A",RETURN NEXT FRIDAY, IF(A1="B",RETURN NEXT TUESDAY.....ETC
The reason I need this is because I have a group of accounts and each of them has a specified delivery date, so if an account has been assigned to group A they will take delivery on Mondays, and if they have been assigned to group B, delivery will be Tuesdays etc.
I think from these examples the formula will result in a different day and date dependent on what day "today" is. What I need is for each account in group A to default to the next Monday, regardless of what day of the week it is currently. So group A would be today+4 if it is Monday but today+3 if it is Tuesday. I hope this makes sense.