Forum Discussion
Solved
Please Help with complex conditional formula to determine headcounts per each month
Dear Team, I find myself in a tight corner with excel today. My GOAL: to be able to calculate the headcount (HC) in the company on a monthly basis. My intention for area highlighted blue with...
In N2:
=($J2<EOMONTH(N$1,0))*(IF($G2<>"",$G2,IF($K2<>"",$K2,DATE(2099,12,31)))>=N$1)*($I2<>"not EHQ HC")*($I2<>"EXTERNAL")
Fill down, then to the right, or vice versa.
In N2:
=($J2<EOMONTH(N$1,0))*(IF($G2<>"",$G2,IF($K2<>"",$K2,DATE(2099,12,31)))>=N$1)*($I2<>"not EHQ HC")*($I2<>"EXTERNAL")
Fill down, then to the right, or vice versa.