Minimum date greater than a specific date.
 

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

Minimum date greater than a specific date.
 

=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


"Joker" wrote:

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

Minimum date greater than a specific date.
 

=MIN(IF(A39:A46V50,A39:A46)

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Joker" wrote in message
...
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

Minimum date greater than a specific date.
 

Thank you very much. That works great!

"Bob Phillips" wrote:

=MIN(IF(A39:A46V50,A39:A46)

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Joker" wrote in message
...
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