i think you will have to sort or put them in another helper column sorted descending and use
=MATCH(TODAY()+1,H1:H12,-1)
or then again perhaps donkeyote will come up with some array
oooh what a surprise as i type there it is