T
TBA
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?
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?