Hi Again,
Is there a way to display an actual date instead of the day?
Current formula;
INDEX(FILTER($B$3:$D$9,$A$3:$A$9=TEXT(G2,"ddd")),{3,1,2})
for example;
Currently formula above displays:
Could it show:
the MP dates will change throughout the year.
Collection times are fixed for Wednesday - 11:00 and Saturday and Sunday will always be 13:00.
thanks
Is there a way to display an actual date instead of the day?
Current formula;
INDEX(FILTER($B$3:$D$9,$A$3:$A$9=TEXT(G2,"ddd")),{3,1,2})
A | B | C | D | |
1 | Will be 2 days before MP Day | Will be 2 days before Collection date | ||
2 | MP Day (can be any date) | Collection Day | Collection Time | Dispatch Notification |
3 | Mon | Sat | 13:00 | Thurs |
4 | Tue | Sun | 13:00 | Fri |
5 | Wed | Sun | 13:00 | Fri |
6 | Thu | Wed | 11:00 | Mon |
7 | Fri | Wed | 11:00 | Mon |
8 | Sat | Wed | 11:00 | Mon |
9 | Sun | Sat | 13:00 | Thurs |
for example;
MP Day | Dispatch Notification | Collection Day | Collection Time |
Wed, 02-Feb-22 | Fri, 28-Jan-22 | Sun, 30-Jan-22 | 13:00 |
Currently formula above displays:
MP Day | Dispatch Notification | Collection Day | Collection Time |
Wed, 02-Feb-22 | Fri | Sun | 13:00 |
Could it show:
MP Day | Dispatch Notification | Collection Day | Collection Time |
Wed, 02-Feb-22 | Fri, 28-Jan-22 | Sun, 30-Jan-22 | 13:00 |
the MP dates will change throughout the year.
Collection times are fixed for Wednesday - 11:00 and Saturday and Sunday will always be 13:00.
thanks