What I've been using is:
{=SUM(COUNTIF(Holidays,H12:AH13))}
This counts the number of times that the dates match within the work period.
What I was looking for is a way to populate the cell with a 1 on the date it
matches Ex: 1 holiday is added on 1/1/2006 for the new years holiday, and so
on, even if its in the middle of a work cycle. I have each of the actual
dates listed in the named range...Ben

"daddylonglegs" wrote:


If I understand correctly you want to count how many dates within your
range fall between A1 and A2. If so

=SUMPRODUCT(--(A12:AH13=A1),--(A12:AH13<=A2))

or

=COUNTIF(A12:AH13,"="&A1)-COUNTIF(A12:AH13,""&A2)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=522428