I'm trying to figure out a function to where Excel will calculate headcount. For example if a person worked any day in that month, I need Excel to calculate that as 1 headcount for that month. Also if that person is leaving within the coming month's I need to forecast that person leaving also. I've tried the following function:
A1=Start Date
C1=End Date
B1=First Day of the Month in Question
This IF statement works fine, but it does not capture headcount for people who only worked for a few days or so in the month. For example if A1=8/5/09, C1=8/10/09, and B1=8/1/09, then someone under this circumstance would fall through the cracks so to speak. Can someone help me with this? I'm so close, but yet so far. TIA...
Bookmarks