Hi,
I am wanting to get the minimum date from sheet "Orders" column "F" based on cell a2 cross referenced with row "Orders" column "A"
So column A in orders is numbers 1 - 10 multiple times
Column F in Orders is multiple different dates (some the same date)
so in another sheet cell I2 i am wanting the earliest date from the value of cell A2 with the above data to bring back earliest date
i currently have a formula that shows if its within 5 days or less of todays date put today +14, but i need the exact information now.
=IF(H9=0,"",IF(IF(COUNTIF(Orders!A:A,Link!A9)>0,MIN(IF(Orders!$A:$A=Link!A9,Orders!$P:$P)),"")<TODAY()+5,TODAY()+14,IF(COUNTIF(Orders!A:A,Link!A9)>0,MIN(IF(Orders!$A:$A=Link!A9,Orders!$P:$P)),"")))
this is the formula ive been using.
Link is the sheet i am doing the formula on
thanks
I am wanting to get the minimum date from sheet "Orders" column "F" based on cell a2 cross referenced with row "Orders" column "A"
So column A in orders is numbers 1 - 10 multiple times
Column F in Orders is multiple different dates (some the same date)
so in another sheet cell I2 i am wanting the earliest date from the value of cell A2 with the above data to bring back earliest date
i currently have a formula that shows if its within 5 days or less of todays date put today +14, but i need the exact information now.
=IF(H9=0,"",IF(IF(COUNTIF(Orders!A:A,Link!A9)>0,MIN(IF(Orders!$A:$A=Link!A9,Orders!$P:$P)),"")<TODAY()+5,TODAY()+14,IF(COUNTIF(Orders!A:A,Link!A9)>0,MIN(IF(Orders!$A:$A=Link!A9,Orders!$P:$P)),"")))
this is the formula ive been using.
Link is the sheet i am doing the formula on
thanks