Forum Discussion
Solved
What's the best formula to use in based on the below - r.e. date =if conditioning
hello what's my best formula for the below a b c d Trading week Day Delivery date Despatch Date 1 Sunday 10/01/2022 09/01/2022 ...
The formula in D can check if the weekday of the date in C is a Monday. If so, deduct 2 days to avoid Sundays, otherwise deduct 1 day.
The formula in D can check if the weekday of the date in C is a Monday. If so, deduct 2 days to avoid Sundays, otherwise deduct 1 day.
- yes worked perfect, many thanks
