hi
I want to know the formula that will lookup criteria of weekday (B1) and refer my inpnut date (A4), then it will return the next closest date of the weekday I set.
Myabe i cannot explain clearly, let's see my table and return column is the date I want excel to return. Can a simple formula do that for me? thank you
I want to know the formula that will lookup criteria of weekday (B1) and refer my inpnut date (A4), then it will return the next closest date of the weekday I set.
Myabe i cannot explain clearly, let's see my table and return column is the date I want excel to return. Can a simple formula do that for me? thank you
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Cut | Wed | ||||
2 | ||||||
3 | input | return | ||||
4 | 8-Oct | 9-Oct | ||||
5 | 9-Oct | 9-Oct | ||||
6 | 10-Oct | 16-Oct | ||||
7 | ||||||
Sheet1 |