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~
|