View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Daren Daren is offline
external usenet poster
 
Posts: 162
Default 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