View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pat67 pat67 is offline
external usenet poster
 
Posts: 48
Default putting a date in an if statement

When i write an if statement taht says this =IF(J2<6/1/2010,"N/A",J2),
it always comes up false. How do make it see the date?