=MAX(D7:37)-TODAY()

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Qaspec" wrote in message
...
I'd like to find out the number of days between todays date and the latest
date from a range of dates (D7:D37). Thanks for any help.