IF Statement for Dates
Thanks. That's a good approach, but I want to check all four dates against
each other using IF and then use conditional formatting and do this only in
one cell. Can you assist further?
"Gary''s Student" wrote:
Put the four dates in A1 thru D1
In B2 enter:
=IF(B1<A1,"value above is out of order","")
then copy B2 to C2 thru D2
--
Gary''s Student - gsnu200810
|