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 Name||Start Date||End Date|
|NG61AA0||01/11/2016 00:00||25/05/2017 00:00|
|Rpellegrino||06/06/2005 00:00||16/09/2011 00:00|
|snioolic||01/01/2016 00:00||25/09/2016 00:00|
|SUP017||16/07/2015 00:00||18/12/2015 00:00|
|T1429||01/10/2016 00:00||27/01/2017 00:00|
|GR43LI||17/09/2007 00:00||11/08/2010 00:00|
I've tried so many different ways and I'm about ready to give up.