FryGirl
Well-known Member
- Joined
- Nov 11, 2008
- Messages
- 1,364
- Office Version
- 365
- 2016
- Platform
- Windows
For some reason, I can't figure out the logic here
I need to compare A2 against the dates in row 1. If the date in row 1 is greater than A2, but less then the next date then place a 1.
Since A2, 19-Oct-16 is greater than D1, but less than E1, then D2 should be a 1.
Data Range
I need to compare A2 against the dates in row 1. If the date in row 1 is greater than A2, but less then the next date then place a 1.
Since A2, 19-Oct-16 is greater than D1, but less than E1, then D2 should be a 1.
Data Range
A | B | C | D | E | |
1 | | 3-Oct-16 | 10-Oct-16 | 17-Oct-16 | 24-Oct-16 |
2 | 19-Oct-16 | 0 | 0 | 1 | 0 |
Last edited: