ExcelBanter - Find number of days between to dates

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Find number of days between to dates (https://www.excelbanter.com/excel-worksheet-functions/9570-find-number-days-between-dates.html)

Qaspec

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.

Bob Phillips

=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.

All times are GMT +1. The time now is 04:29 AM.