Help with figuring date that 25 months from a the fifth newest date in a list. Chase 5/24 rule

[edgarperez]

I have a spreadsheet that is full of credit card application dates. Chase has a rule where it will automatically decline a credit card application if you have received more than 5 credit cards, from any institution, in the last 24 months.

With that said, I want to do a formula to figure the date at which it is safe to apply for a new credit card at Chase.

FYI, I do it for the points.

So basically I need it to look at all the dates, figure if I have more than 5 within the last 24 months, and then give me a date, 25 months, (giving me one month cushion), from the fifth oldest date in the that group of 5 or more. If it is less than 5 in the past 24 months, give today's date.

Make sense?

I have not been able to figure this one out.

 

[MARK858]

If I am reading this right maybe something like the below will give you 25 months from the 5 oldest date (just about to eat so haven't added in the if statement)?

Excel Workbook
	A	B	C
1	01/05/2018		14/07/2019
2	06/08/2018
3	09/08/2018
4	04/04/2017
5	17/03/2016
6	14/06/2017
7	06/08/2016
8	06/10/2018
9	05/04/2017
10	07/06/2016
Sheet2

 

[MARK858]

Just to update...

Excel Workbook
	A	B	C
1	01/05/2018		14/07/2019
2	06/08/2018
3	09/08/2018
4	04/04/2017
5	17/03/2016
6	14/06/2017
7	06/08/2016
8	06/10/2018
9	05/04/2017
10	07/06/2016
Sheet2

 

[MARK858]

After a re-read....

Excel Workbook
	A	B	C
1	01/05/2018		14/07/2019
2	06/08/2018
3	09/08/2018
4	04/04/2017
5	17/03/2016
6	14/06/2017
7	06/08/2016
8	06/10/2018
9	05/04/2017
10	07/06/2016
Sheet2

 

[edgarperez]

Thanks very much for you help. Was not familiar with EDATE and total forgot about LARGE.

Could not get your last one to work but think this will work for me

=IF(LARGE($A$21:$A$30,5)>EDATE(TODAY(),-25),EDATE(LARGE(A21:A30,5),25),TODAY())

I really don't get why my brain does not want to compute this easy concept but this helps.

 

[MARK858]

The formula in your last post doesn't count if there are less than 5 in the last 24 months.

 

[edgarperez]

you are correct. I get it now and have incorporated your full formula. Thank you very much for your help on this.

The formula in your last post doesn't count if there are less than 5 in the last 24 months.