Here is the example: A1 cell -empty- this is where I want the formula entered. G1 cell - 7/1/08. So in A1 I want to run a formula that would say, if G1 is less than 7/15/08 then A1 should = OLD. If G1 = or greater than 7/15/08 than A1 should =NEW. I want anything that has a date PRIOR to 7/15/08 to return with the answer "OLD" and anything with a date from 7/15/08 and future to return with the answer "NEW" Please help!!!