Greetings, Everyone.

I have a sheet that will have dates between, say, 5 columns. (HH1 - HH5).
What I need is on a second sheet's cell, say 'J6', is if the five columns on
sheet one are filled with dates, put the most recent date in sheety two 'J6'.

Any ideas? I've looked at MAX and DMAX. Not sure what else to try.

It's been a long time since programming, but I'm getting back to it.

Thanks.