Thread: IF Statement for Dates
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default IF Statement for Dates
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
Reply With QuoteReply With Quote