Forum Discussion
Solved
Need help in calculating headcount
Hey There , I need some help to calculate the future Headcount based on the actual headcount ,future joiners and furture endings .. So, I have 3 table , Actual Headcount till Mar , Future starts...
Hi,
I have solved a similar problem in the attached files. Please review my solution and adapt it to your needs.
Thank you Ashish_Mathur for your response,
I assume this will work
| Date | Actual HC | Future Starts | Future Endings | Future HC | Calulation |
| Dec-23 | 2136 | 2136 | |||
| Jan-24 | 2019 | 2019 | |||
| Feb-24 | 1964 | 1964 | |||
| Mar-24 | 1672 | 1672 | |||
| Apr-24 | 213 | 138 | 1747 | =E5+C6-D6 | |
| May-24 | 25 | 247 | 1525 | =E6+C7-D7 | |
| Jun-24 | 313 | 1212 | =E7+C8-D8 | ||
| Jul-24 | 157 | 1055 | =E8+C9-D9 | ||
| Aug-24 | |||||
| Sep-24 | |||||
| Oct-24 | |||||
| Nov-24 | |||||
| Dec-24 |
Hi,
I have solved a similar problem in the attached files. Please review my solution and adapt it to your needs.
Thanks Ashish_Mathur ,It worked .