Number of Departure for Current Quarter in between 24 months

netuser

Active Member
Joined
Jun 19, 2015
Messages
420
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 :)


Excel 2010 32 bit
ABCDE
1EntryDepartureQ12
22012-01-092014-01-13Q21
32012-05-222016-04-11Q30
42015-06-252016-02-28Q40
52012-09-102014-05-09
62015-10-012016-05-13
72012-10-092015-02-01
82015-03-052016-01-18
Nb depart
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Forum statistics

Threads
1,221,831
Messages
6,162,242
Members
451,756
Latest member
tommyw

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top