Is there a way to quickly compare ranges of dates to count how many dates from one dataset fall within 2 weeks of another data set?

[Carterland]

Hey all,

Driving myself mad here, I can't think of any easy way to do this or if it's even possible at all.

Basically for each 'person' I have a list of dates where something was received or requested from them. I then have a list of dates that the 'person' contacted us. What I want to do is count how many times the dates received/requested were within 2 weeks either side of the calls. The issue is there's multiple dates for received, requested and calls. Doing it individually would take forever and wouldn't actually be worth the time involved. Any ideas? I've done the exact matches already easy enough with a count/match combination.


Thanks

I'm running Office 365 64bit

I can't seem to attach a file, I'm unable to install addons due to company restrictions, is there a way to upload an example sheet?

 

[Carterland]

Images may help for now

 

[vladimiratanasiu]

Hey all,

Driving myself mad here, I can't think of any easy way to do this or if it's even possible at all.

Basically for each 'person' I have a list of dates where something was received or requested from them. I then have a list of dates that the 'person' contacted us. What I want to do is count how many times the dates received/requested were within 2 weeks either side of the calls. The issue is there's multiple dates for received, requested and calls. Doing it individually would take forever and wouldn't actually be worth the time involved. Any ideas? I've done the exact matches already easy enough with a count/match combination.


Thanks

I'm running Office 365 64bit

I can't seem to attach a file, I'm unable to install addons due to company restrictions, is there a way to upload an example sheet?

You can use other methods to share your document: Dropbox, Google Docs etc. The image format must be copied manually / converted, that's why it becomes not a very efficient tool to work with.

 

[Carterland]

You can use other methods to share your document: Dropbox, Google Docs etc. The image format must be copied manually / converted, that's why it becomes not a very efficient tool to work with.

Appreciate the advice, sheet link now added to OP.

Thanks again

 

[Carterland]

https://docs.google.com/file/d/1_ymrY301YZmxPCaULKQT8ToD3MIl4K98/edit?usp=docslist_api&filetype=msexcel

Sheet link