Forum Discussion

ritendersingh2's avatar
ritendersingh2
Regular Visitor
2 years ago
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...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Hi,

Share data in a format that can be pasted in an MS Excel file.

  • ritendersingh2's avatar
    ritendersingh2
    Regular Visitor
    2 years ago

    Thank you Ashish_Mathur for your response,

    I assume this will work

    DateActual HCFuture StartsFuture EndingsFuture HCCalulation
    Dec-232136  2136 
    Jan-242019  2019 
    Feb-241964  1964 
    Mar-241672  1672 
    Apr-24 2131381747=E5+C6-D6
    May-24 252471525=E6+C7-D7
    Jun-24  3131212=E7+C8-D8
    Jul-24  1571055=E8+C9-D9
    Aug-24     
    Sep-24     
    Oct-24     
    Nov-24     
    Dec-24