1 Reply Latest reply on Jul 24, 2018 9:44 AM by Shinichiro Murakami

    Calculating the headcount for the last day of each year (start date, end date)

    Aileen Rotondo



      I am trying to create a simple bar chart showing the headcount for the last day of each year. from 2009 to 2018.


      For year 2009 to 2017 I want the headcount for the last day of the year, but for 2018 I want the latest headcount.



      Attached is the excel sample data.

      A null end date means that the employee is still working with the company.




      User NameStart DateEnd Date
      drrnt31/10/2005 00:00null
      Mruff03/01/2012 00:00null
      NG61AA001/11/2016 00:0025/05/2017 00:00
      NG67BBB14/11/2016 00:00null
      Rpellegrino06/06/2005 00:0016/09/2011 00:00
      snioolic01/01/2016 00:0025/09/2016 00:00
      SUP01716/07/2015 00:0018/12/2015 00:00
      T142901/10/2016 00:0027/01/2017 00:00
      GR43LI17/09/2007 00:0011/08/2010 00:00


      I've tried so many different ways and I'm about ready to give up.