Thread: putting a date in an if statement
View Single Post
  #3   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
On May 21, 2:04*pm, "T. Valko" wrote:
=IF(J2<6/1/2010,"N/A",J2)

Excel evaluates that as: IF J2 is less than 6 divided by 1 divided by 2010.
Reply With QuoteReply With Quote