=COUNTIF(N2:BR2,"<" & C2)
will count the number of dates between N2 and PR2 that are less than the
date in C2
--
Gary''s Student - gsnu200847


"TBA" wrote:

Hi there. I want to create a formula to count the number of dates that fall
before or after a set date. The sheet is structured so that there is a
column with the date of an interview, call it 'E'.
There are then a number of dates recorded in rows €˜N to €˜AP. I want to
create two separate formula that count the number of dates between €˜N and
€˜AP that fall before or after the date in €˜E. I tried:
€œ=COUNTIF(N2:BR2,N2:BR2<C2)€� but it returns €˜0. Any suggestions?