thousand
New member
- Joined
- Apr 2, 2017
- Messages
- 30
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2010
Worksheet1
Worksheet2
Is there a formula that identifies Peter has completed activity2 within 20 days of activity1?
Vlookup doesn’t really do the trick as it will pick up 1/3/18 rather than 15/1/18. If I sort worksheet2 by oldest to newest then the second Peter in worksheet1 will not pick up he had activity for 15/Jun/18.
Name | Activity1 | 20 days after | Activity1 within 20days of Activity2? |
Peter | 1/Jan/18 | 21/Jan/18 | (vlookup will identifty 1/Mar/18) I want it to pick up 15/Jan/18 |
Peter | 1/Jun/18 | 21/Jun/18 | (vlookup will identifty 1/Mar/18) I want it to pick up 15/Jun/18 |
Worksheet2
Name | Activity2 |
Peter | 1/Mar/18 |
Peter | 15/Jan/18 |
Peter | 15/Jun/18 |
Is there a formula that identifies Peter has completed activity2 within 20 days of activity1?
Vlookup doesn’t really do the trick as it will pick up 1/3/18 rather than 15/1/18. If I sort worksheet2 by oldest to newest then the second Peter in worksheet1 will not pick up he had activity for 15/Jun/18.