formula for countif between 2 dates
 

I want to do a headcount by month. I list startdates in "C" and
terminationdates in "D".

Thanks~

hi,

Use the MONTH function whic will return the month of the start date and end
date and then by countif function you can go ahead.

A lot of ways where you can find out however after this month function i
guess u will be albe to figure out

hitesh

"ilmeaz" wrote:

I want to do a headcount by month. I list startdates in "C" and
terminationdates in "D".

Thanks~

Thanks for your response. I guess I need to clarify that this covers a
number of years also. I can use YEAR and MONTH to make two new columns and
do a nested countif but I was hoping for something that would explain how to
get dates recognized within a countif formula.

My first stab, which didn't work because the dates weren't recognized may
give you an idea of where I am headed. It was:
=countif((c2:c897<=1/1/1995 <2/1/1995)-(d2:d897<=1/1/1995 <2/1/1995)
I'll keep playing with your suggestion and see what I get.

Thanks!!

"HITESH" wrote:

hi,

Use the MONTH function whic will return the month of the start date and end
date and then by countif function you can go ahead.

A lot of ways where you can find out however after this month function i
guess u will be albe to figure out

hitesh

"ilmeaz" wrote:

I want to do a headcount by month. I list startdates in "C" and
terminationdates in "D".

Thanks~