Hi there,
I need help with calculating tenure by month based on start date & end date provided. Please find below a screenshot of the chart I have to fill in, including my current attempt at a formula that is giving me the wrong answers but im not sure why.
=COUNTIFS(Data!$D:$D,">="&DATE(2015,2,1),Data!$D:$D,"<="&DATE(2018,1,31))+(COUNTIFS(Data!$E:$E,""<=""&DATE(2020,2,28),Data!E:E,""))
From this I am trying to get a count of employees who are still employed in the month February but have 2-5 years of tenure (hired between Feb,1, 2015 - Jan,31, 2018). It is pulling the correct # but it is not excluding the person that left the company on Feb 7, 2020 ( still including the people who left after the month of February) & I am not sure why. Please see snapshot below of the chart I have to fill in + an example of the format of the data attached.
Thanks in advance!
Capture.JPG
Bookmarks