MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Becca on October 30, 2001 8:17 AM

I am trying to use the FORECAST function to project
needed headcount for the rest of the year. I have the
number needed for each month, january thru september.
I think this function will project October-December.
If someone could share the details on how to use this,
I would appreciate it.

Thank you.

Posted by Aladin Akyurek on October 30, 2001 10:10 AM


Lets say that A1:B9 houses the following data:


In B10 enter: =TREND(B1:B9,,{10;11;12})

Select B10:B12, go to the Formula Bar, and hit CONTROL+SHIFT+ENTER at the same time.

You'll see the projected head counts in B10:B12 for Oct thru Dec that I believe will not be far off what you want.



Posted by Mark W. on October 30, 2001 2:00 PM

Becca, forecasting Q4 headcount based on Q1-Q3 is a dicey proposition...

...because you're not considering the cyclical
nature of business activity. A much more
reliable approach would be compare headcount
for a like period such as the last 5 years' 4th
quarter census with adjustments for annual growth.