ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Formula Question (https://www.excelbanter.com/excel-worksheet-functions/203988-formula-question.html)

Sarah

Formula Question
 
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.



All times are GMT +1. The time now is 08:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com