in column AD:3-700 i have a formula = =IF(R4="",B4,"") which if meets the conditions, gives me B which is a date... im trying to get the oldest date in the column however using this forumula =MIN(AD3:AD700) it just returns a blank cell... any ideas?