title: Excel 2010 - Find Records With Last Date Prior to Given Time
body: <p>I have a spreadsheet with a list of users and all the timestamps for their logins for the past two years.  I want to find all the users who have not logged in for specified periods of time -- say, not within the past month, not within the past two months.  </p>
  
  <p>How can I do this?</p>
  
  <p>The data are in two columns, user ID and login date/time stamps.</p>
  
  <pre>
  user1 11/3/10 13:21
  user1 1/3/11 12:54
  user1 1/23/11 9:58
  user2 10/2/10 10:13
  ...
  </pre>
  
  <p>Date and time are a single column.</p>
  
  <p>I can see how to find, say users that logged in prior to a particular date but not how to exclude at the same time, those who logged in after that date.</p>
  
  <p>Any help would be much appreciated.</p>
  
  <p>Thanks.</p>
  
  <p>mp</p>