Formula Finding Headcount Based on Start and End Dates

[shilos_dad]

I found this solution here in one of the threads here's the link.

Formula to calculate headcount based on start/leave dates, governed by selectable dropdowns.

the solution given was assumed headcount based on the first day of the month.

where should i put the EOMONTH function to get the end of month counts?

here's the formula from the thread

=COUNTIFS($H$2:$H$30,"<="&DATE($B$36,MATCH($C$36,$R$1:$R$12,0),1),$I$2:$I$30," ")+COUNTIFS($H$2:$H$30,"<="&DATE($B$36,MATCH($C$36,$R$1:$R$12,0),1),$I$2:$I$30,">="&DATE($B$36,MATCH($C$36,$R$1:$R$12,0),1))

 

[jorismoerings]

Hi,

wrap it around ALL the DATE functions. As an example, this part

DATE($B$36,MATCH($C$36,$R$1:$R$12,0),1)

becomes

EOMONTH(DATE($B$36,MATCH($C$36,$R$1:$R$12,0),1),0)

 

[shilos_dad]

Hi,

wrap it around ALL the DATE functions. As an example, this part

becomes

EOMONTH(DATE($B$36,MATCH($C$36,$R$1:$R$12,0),1),0)

hi Joris, thanks..formula worked.