Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
minimum greater than zero | Excel Worksheet Functions | |||
Formula for placings, using 4 times and greater than minimum time | Excel Worksheet Functions | |||
Trying to make cell "date sensitive" to specific date | Excel Discussion (Misc queries) | |||
How do I make a cell date specific to input a value on a specific. | Excel Discussion (Misc queries) | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel |