title: Excel formula to check date within this week and last week
body: <p>Does anyone know an excel formula in which if the dates are within this week (Todays date) for the cells to read the text “this week” and if the dates are from the last week for the cells to read “last week”.</p>
  <p>Ps: If the formula could also read &quot;old&quot; if the date range is not with this week or last week</p>
  <p>Example: Column A has the following dates. I want column b to read whether or not the date is within this week or last week from today’s date.</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Column A</th>
  <th>Column B</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>01/11/2013</td>
  <td>Old</td>
  </tr>
  <tr>
  <td>02/11/2013</td>
  <td>Old</td>
  </tr>
  <tr>
  <td>03/11/2013</td>
  <td>Old</td>
  </tr>
  <tr>
  <td>04/11/2013</td>
  <td>Old</td>
  </tr>
  <tr>
  <td>05/11/2013</td>
  <td>Old</td>
  </tr>
  <tr>
  <td>06/11/2013</td>
  <td>Old</td>
  </tr>
  <tr>
  <td>07/11/2013</td>
  <td>Old</td>
  </tr>
  <tr>
  <td>08/11/2013</td>
  <td>Old</td>
  </tr>
  <tr>
  <td>09/11/2013</td>
  <td>Old</td>
  </tr>
  <tr>
  <td>10/11/2013</td>
  <td>Old</td>
  </tr>
  <tr>
  <td>11/11/2013</td>
  <td>Old</td>
  </tr>
  <tr>
  <td>12/11/2013</td>
  <td>Old</td>
  </tr>
  <tr>
  <td>13/11/2013</td>
  <td>Old</td>
  </tr>
  <tr>
  <td>14/11/2013</td>
  <td>Last week</td>
  </tr>
  <tr>
  <td>15/11/2013</td>
  <td>Last week</td>
  </tr>
  <tr>
  <td>16/11/2013</td>
  <td>Last week</td>
  </tr>
  <tr>
  <td>17/11/2013</td>
  <td>Last week</td>
  </tr>
  <tr>
  <td>18/11/2013</td>
  <td>Last week</td>
  </tr>
  <tr>
  <td>19/11/2013</td>
  <td>Last week</td>
  </tr>
  <tr>
  <td>20/11/2013</td>
  <td>Last week</td>
  </tr>
  <tr>
  <td>21/11/2013</td>
  <td>This Week</td>
  </tr>
  <tr>
  <td>22/11/2013</td>
  <td>This Week</td>
  </tr>
  <tr>
  <td>23/11/2013</td>
  <td>This Week</td>
  </tr>
  <tr>
  <td>24/11/2013</td>
  <td>This Week</td>
  </tr>
  <tr>
  <td>25/11/2013</td>
  <td>This Week</td>
  </tr>
  <tr>
  <td>26/11/2013</td>
  <td>This Week</td>
  </tr>
  <tr>
  <td>27/11/2013</td>
  <td>This Week</td>
  </tr>
  <tr>
  <td>28/11/2013</td>
  <td>This Week</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Big thanks to anyone who can solve this please.</p>