Background, I am checking the start dates for agile sprints against a specific range
Data is like this...
I need to run a check on all 'sprint start dates' and see if any of those dates are within 3 days (plus or minus) of any of the 'anchor start dates'. I need to have a 'yes or no' value in the 'within range' column. I've tried using DATEDIF, nested AND statements. Can't seem to get it to work.
Thanks all!
-joe
Data is like this...
Anchor Start Date | Sprint Start Date | Within Range? |
1/1/20 | 1/3/20 | |
1/15/20 | 1/6/20 | |
1/29/20 | 1/28/20 |
I need to run a check on all 'sprint start dates' and see if any of those dates are within 3 days (plus or minus) of any of the 'anchor start dates'. I need to have a 'yes or no' value in the 'within range' column. I've tried using DATEDIF, nested AND statements. Can't seem to get it to work.
- So if I check 1/3/20 against the list of all anchor dates it should return 'yes'
- If I check 1/6/20 against the list of all anchor dates it should return 'no'
Thanks all!
-joe