Hi,
I have a question, i have a list of dates and when the date falls within the week commencing date range i want it to display a number (1 in this example).
below is a small data set showing what I need it to look like.
hopefully someone can help?
Thanks!!
I have a question, i have a list of dates and when the date falls within the week commencing date range i want it to display a number (1 in this example).
below is a small data set showing what I need it to look like.
hopefully someone can help?
Thanks!!
A | B | C | D | E | |
1 | APR | APR | APR | APR | |
2 | Week Commencing | 02/04/2023 | 09/04/2023 | 16/04/2023 | 23/04/2023 |
3 | 8-Oct-23 | ||||
4 | 25-Apr-23 | 1 | |||
5 | 26-Apr-23 | 1 | |||
6 | 27-Apr-23 | 1 | |||
7 | 28-Apr-23 | 1 | |||
8 | 29-Apr-23 | 1 | |||
9 | 30-Apr-23 | 1 | |||
10 | 5-Apr-23 | 1 | |||
11 | 5-Apr-23 | 1 | |||
12 | 5-Apr-23 | 1 | |||
13 | 5-Apr-23 | 1 |