Simple Formulas to list ALL Next payments due (Closest Date to Today) from a list

[EmadMassoud]

Hi

I am working on an Excel Sheet for the Monthly Bills payments. I want simple Formulas (I am using Excel 2016) without codes to return:

1- The next payment due in C17 (closest dates to Today).
Note: there are more than one same dates in the list. I used the Formula [ MIN(IF($C$2:$C$14>TODAY(),$C$2:$C$14)) ] in C17 but it gives me only the first closest future date to today

2- The next Monthly payments due (from today) [especially if more than one payment due] in Cells D17, D18 ...... respectively

3- The corresponding bill amounts in E17,E18 ....respectively

4- The corresponding Payees in F17,F18...respectively

Thank you

A

B

C

D

E

F

Monthly payments	Amount	Due Date	PAYEE
MORTGAGE	$1,200.00	February 01, 2022​	AA
PROPERTY TAX	$200.00	February 01, 2022​	BB
HOUSE INSURANCE	$100.00	February 13, 2022​	CC
ELECTRICITY	$150.00	February 24, 2022​	DD
NATURAL GAS	$85.00	February 24, 2022​	EE
WATER & SERVICES	$45.00	February 05, 2022​	EE
WASTE & RECYCLYING	$50.00	February 05, 2022​	EE
INTERNET	$80.00	February 01, 2022​	FF
WATER FILTER	$85.00	February 01, 2022​	GG
MAIL FORWARDING	$15.00	February 01, 2022​	HH
AUTO INSURANCE	$65.00	February 13, 2022​	II
CELL PHONE	$55.00	February 12, 2022​	JJ
OTHER	$90.00	February 01, 2022​	KK
Today Date:		February 16, 2022​		AMOUNT	PAYEE
Next Payments DUE on		February 24, 2022​	ELECTRICITY	$150.00	DD
			NATURAL GAS	$85.00	EE