Hi
I am trying to count the "current" employees in each month, including those who have started and left within the month i.e. excluding those who have left and who have not yet started
I have tried using COUNTIFS to count ""s (blanks) as a criteria but keep getting 0. I have a long winded formula but there is I am sure a much better way.
Please see attached.
Thanks
Cortlyn
Bookmarks