Snasui Excel Forum

Hi there,

i need your help how to return date before today date in color cell and balance in color cell as well.

i need formula to do that

tks

I guess,

D3 =AGGREGATE(14,6,RIGHT($A$2:$A$49,10)/(RIGHT($A$2:$A$49,10)+0<=TODAY()),1)
E2 =INDEX(B2:B49,MATCH("*"&TEXT(D3,"dd-mm-yyyy"),A2:A49,0))

Hope this help.

got it,tks