if formula with dates criteria
Posted on 2014-03-26
Hi Experts excel 2007
I have the following of formula in cell b2
If (A2="", if (c2="","", c2), VLOOKUP (a2,'sheet2'! $ a $2:$b $20,2, False))
Fine works 100%...
Need to include following steps...if g2 has a dates less then todays date and h2 is blank no date then replace c2 with complete. ..if g2 had a date less ten today's date and h2 has a future date then in replace c2 with in progress. .