Thread: If then Statement for Excel Columns
View Single Post
  #4   Report Post  
zoio zoio is offline
Junior Member
  
Posts: 2
Default
Great!

Thanks,
Zoio

Quote:
Originally Posted by James Ravenswood View Post
In E1 enter:

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