Count number of products on sale on different dates throughout time.

[bark01]

Hi,

I'm trying to produce a table that shows over time the most amount of products that have been sale at any given time.

My data is arranged with Product name [column A], Sales start date in , Sales end date [C].

I'm trying to arrange the data so I have a date column, then the cell next to it shows the number of products on sale on that date.

Any help would be appreciated

thanks

 

[Andrew Poulsom]

See if you can adapt this

=COUNTIFS(B:B,"<="&D1,C:C,">="&D1)