L
latsyrc57
Have Today() (08/27/2009) in A1, have a date in D9 (09/04/2009) and another
date in E9 (09/11/2009).
If A1 is less than D9, then I want F9 = G9
If A1 is greater than D9 but less than E9, then I want F9 = H9
If A1 is greater than both D9 and E9, I want F9 = I9
Using Excel 2003
date in E9 (09/11/2009).
If A1 is less than D9, then I want F9 = G9
If A1 is greater than D9 but less than E9, then I want F9 = H9
If A1 is greater than both D9 and E9, I want F9 = I9
Using Excel 2003