Minimum date greater than a specific date.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am looking for a formula to give me the minimum date from a list of dates
greater than 90 days ago. In column A from cell A39 to A46 I have a list of
dates. In cell V50 I have =today()-90. I need the date that is the earliest
from the date in cell V50. Any help would be appreciated. Thank you
 
=TEXT(IF(MIN(A39:A46)<=V50,MIN(A39:A46),"No dates older than 90
days"),"mm/dd/yyyy")

All on one line, watch out for email wordwrap..........

Vaya con Dios,
Chuck, CABGx3
 
=MIN(IF(A39:A46>V50,A39:A46)

which is an array formula, so commit with Ctrl-Shift-Enter

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Thank you very much. That works great!

Bob Phillips said:
=MIN(IF(A39:A46>V50,A39:A46)

which is an array formula, so commit with Ctrl-Shift-Enter

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
Click to expand...
 

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

several conditional formats for dates 4
Using Dates with the IF function 2
Trailing 30 days sum calculation with excel 1
Minimum Date Greater Than Observation Start Date 2
Formula Greater than Less Than 4
count if function using dates 1
Using SUMIFS with date range 4
Conditional Format where ANY date is >= 30, 60, 90 days EXCEL 2007 1

Back
Top