Thread: If then Statement for Excel Columns
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
James Ravenswood James Ravenswood is offline
external usenet poster
  
Posts: 143
Default If then Statement for Excel Columns
In E1 enter:

=IF(K1<DATEVALUE("1/8/2011"),"Old","New")
and copy down
Reply With QuoteReply With Quote