Find number of days between to dates

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.

=TODAY()-MAX(D7:D37)

and format as Number with no decimals

=MAX(D7:37)-TODAY()

--

HTH

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


"Qaspec" <[email protected]> wrote in message
news:[email protected]...
> 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.