I have a table with Column A containing Entry date and Column B Departure Date (will be empty if no departure so should be ignored)
I need to find out for the Current Quarter How many departure I had who did not completed 24 months
So if I am in Quarter 2 it should look all departure dates from April 2016 to June 2016 and then calculate the number of months between entry and departure if it is <24 then it will Count
In this example below I have 2 departure in last 24 M in Q1 (row 4 and row 8) and 1 in Q2 Row 6 (note the Row 3 is not counted as it is more than 24 months)
Thanks
I need to find out for the Current Quarter How many departure I had who did not completed 24 months
So if I am in Quarter 2 it should look all departure dates from April 2016 to June 2016 and then calculate the number of months between entry and departure if it is <24 then it will Count
In this example below I have 2 departure in last 24 M in Q1 (row 4 and row 8) and 1 in Q2 Row 6 (note the Row 3 is not counted as it is more than 24 months)
Thanks
Excel 2010 32 bit | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Entry | Departure | Q1 | 2 | |||
2 | 2012-01-09 | 2014-01-13 | Q2 | 1 | |||
3 | 2012-05-22 | 2016-04-11 | Q3 | 0 | |||
4 | 2015-06-25 | 2016-02-28 | Q4 | 0 | |||
5 | 2012-09-10 | 2014-05-09 | |||||
6 | 2015-10-01 | 2016-05-13 | |||||
7 | 2012-10-09 | 2015-02-01 | |||||
8 | 2015-03-05 | 2016-01-18 | |||||
Nb depart |