try this =MAX(I8:I38)

Regards,
KL


"coal_miner" wrote in message
...
Greetings. Allow me to explain my need. I have a column for A/R for
month
of August. 8.01.05 is row I8, 8.31.05 is I38. I need a formula in I39
that
will take the most recent day and use that for I42. I do not need any
calculations, just a formula that will take the mose recent day and
display
it. Thanks for any help.