Hi,

I'm trying to count the number of the same values, "H" (in row 2), horizontally with a date range (row 1), dependent on 2 dates in other cells (B2 & C2), i.e count the number of "H" between the 2 dates within the date range horizontally above the data, as illustrated below.




Crew Member Start Date Yr 1 End Date Y1 H 01-Dec-15 02-Dec-15 03-Dec-15 04-Dec-15 05-Dec-15 06-Dec-15 07-Dec-15 08-Dec-15 09-Dec-15
MR SMITH 03-Aug-15 02-Aug-16 W W H H W W W W W

Any help greatly appreciated.

Thanks