Hi People,
this issue i am facing is counting average headcount in a quarter.
the long way is i have monthly headcount which i average
for the monthly HC (headcount) of march i use countif
Countif(join Date column, <April 1) minus Countif (attrite date column, <April 1) ---sum all heads joined before april 1 and minus all attrite before april 1.
then average the monthly HC of each month to get the quarterly HC.
How can i do the quarterly HC directly using formulas.
this issue i am facing is counting average headcount in a quarter.
the long way is i have monthly headcount which i average
for the monthly HC (headcount) of march i use countif
Countif(join Date column, <April 1) minus Countif (attrite date column, <April 1) ---sum all heads joined before april 1 and minus all attrite before april 1.
then average the monthly HC of each month to get the quarterly HC.
How can i do the quarterly HC directly using formulas.