title: matching a date in a google spreadsheet
body: <p>I am trying to match a date within a google spreadsheet, but I am new to this, and I could use some help.  I have a column that contains a list of birthdays.  I have a cell that I am using to reference for the current date by using </p>
  
  <pre><code>=Today()
  </code></pre>
  
  <p>What I would like to do is compare the month and day, but ignore the year, and return the values in the two adjacent columns.  I am using this query to try to get the information.</p>
  
  <pre><code>=QUERY(C2:E430; "select * where C = date '" &amp; text(F2,"yyyy-MM-dd") &amp; "'")
  </code></pre>
  
  <p>but it always returns an empty output, because the year never matches.  How do I get it to ignore the year?</p>
  
  <p>Thank you,</p>
  
  <p>Paul</p>