count number of dates in a row of cel before or after a variable d

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?
 
P

Per Jessen

Hi

Try to enter a "=Countif( " sign in your formula cell and then click
the equal sign left to the formula line, now fill in your range and
condition and hit enter.

The Formula should look like this:


=COUNTIF(N2:BR2,"<E2")

Hopes this helps.
 
G

Gary''s Student

=COUNTIF(N2:BR2,"<" & C2)
will count the number of dates between N2 and PR2 that are less than the
date in C2
 
T

TBA

thanks very much for that- would you mind explaining the use of the quote
marks and the & ? cheers
 
T

TBA

one last request on this one.
the number of dates in N to AP vary from line to line.
how would I get a formula to tell me what the earliest date in the group of
cells is?

thanks
 
F

Fred Smith

As dates are just numbers to Excel, the earliest is:
=min(n2:ap2)

Regards,
Fred.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top