View Single Post
  #2   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 a date

=IF(A6<DATEVALUE("5/11/2009"),0.324,0.335)

--
Gary''s Student - gsnu200857