Ronnie12345
New Member
- Joined
- Mar 24, 2017
- Messages
- 18
Hi excel wizards,
I need to find if dates are in holiday date ranges
For example is 03/01/2020 within the date ranges below.
I could do this with a nested IF statement but I'm determined to evolve beyond that!
Can you suggest a formula to do this, please?
01/01/2020 05/01/2020
15/02/2020 23/02/2020
04/04/2020 19/04/2020
23/05/2020 31/05/2020
21/07/2020 30/08/2020
24/10/2020 01/11/2020
19/12/2020 31/12/2020
I need to find if dates are in holiday date ranges
For example is 03/01/2020 within the date ranges below.
I could do this with a nested IF statement but I'm determined to evolve beyond that!
Can you suggest a formula to do this, please?
01/01/2020 05/01/2020
15/02/2020 23/02/2020
04/04/2020 19/04/2020
23/05/2020 31/05/2020
21/07/2020 30/08/2020
24/10/2020 01/11/2020
19/12/2020 31/12/2020