formula to derive list clients who has become overdue

[vinod9111]

Hi,

Need a formula to derive list of clients who has become overdue

Client Date
A 31/3/2017
B 25/3/2017
C 15/3/2017
D 5/3/2017

If the due is 17/3/2017, i want the formula to throw client name C and D who has become overdue.

any help will be appreciated.

regards.
Vinod

 

[vinod9111]

Superb Peter, thanks a lot...

 

[Peter_SSs]

Superb Peter, thanks a lot...

Glad it worked for you. Thanks for letting us know.