Ok i think i got it. It all just kinda came together.

I edited my friends formula a little bit to give me what i wanted.

For anyone that can make sense of my ramblings, i used;

=IF(E14>TODAY(),E14,IF(E14=TODAY(),E14,IF(G14>TODAY(),G14,IF(H5>TODAY(),H5,IF(I14>TODAY(),I14,"")))))

File attached. See cell F14.Housekeeping - fixed.xlsm