3 Replies Latest reply on Sep 14, 2015 11:07 PM by Elizabeth Bingham

    Calculating Headcount and Attrition - Day/Week/Month/Year

    Syed Khadir Ahmed

      Hi All,

       

      I am stuck with a Calculation, I am able to see the Year on year Headcount and Attrition using the parameter in the Attached Spreadsheet.

       

      My problem is .. I wanted to have a view of all the years since the first hire till date.. and I should be able to drill down from Year to Quarter to Month to Week and Date...

       

      Unfortunately I do not have a an Calendar... and Even if I attach I am not getting the trick to accomplish the result..

       

      I am attaching a Sample workbook.. please advise as how this can be done.. Thanks in advance.. :-)

       

      kettan Joe Oppelt  (Can you please look into it) :-)

       

      Thank you!!


      Regards,

      Khadir.