Formula Question

S

Sarah

I have a list of advertisements with the following information:

Ad Order Number
Insertion Date

Background information: One ad can run on multiple days, both consecutive
and non-consecutive. Ad count would be as follows:

Ad Order A runs 9/1 - 9/3 consecutively = 1 ad
Ad Order B run 9/1 and 9/3 individually = 2 ads

I would like to count how many individual ads (so with the example above it
would be 3) there are in a specific time frame.....please let me know what
additional informaiton you woudl need to assist me with this problem.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top