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