Find number of days between to dates

Q

Qaspec

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

Bob Phillips

=MAX(D7:37)-TODAY()

--

HTH

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show value from one cell in another cell if today falls between a date range 5
Counting days from a date 3
Dcount -Date Criteria - Won´t find it - 0
Expanding Date Formula 0
Calculating days spent to complete a task 2
Autofill Date in Word 15.33 for Mac 0
Search closest day in the past from today 2
Lookup whole sheet and add datas from specified date to end date 0

Top