Nearest due date formula

[socialvyom]

Hi,
I am trying to get the nearest due date from the attached sheet which have tabs for each month of the year. The condition is whenever the excel sheet is opened it checks the todays date ignore the dates before today and brings up the nearest due date after today. I am using the below formulas

=INDEX(P2:P13,MATCH(MIN(ABS(P2:P13-TODAY())),ABS(P2:P13-TODAY()),0))

Where in P2:P13 I have put a formula for each monthly tab
=INDEX('Jan 18'!B3:B25,MATCH(MIN(ABS('Jan 18'!B3:B25-TODAY())),ABS('Jan 18'!B3:B25-TODAY()),0))

Both these formulas were entered using CTRL+SHIFT+ENTER.
This formulas is ignoring dates from 2017 but from strange reason not ignoring 10th or 11th Jan.




P.S.- Both the above formulas were copied from web and customised, I still don't have a clue how they work.

[bebo021999]

You use ABS that rejected the date in past.
Try date-TODAY >0 as criteria
In P2:

Please Login or Register  to view this content.

[kvsrinivasamurthy]

ARRAY formula in Q2 then drag down

Please Login or Register  to view this content.