title: Automatically find start and end of the work week in a Google Spreadsheet
body: <p>My work week goes from Monday to Sunday and I need to find a way to have 2 different cells automatically update based on =today() what the actual date of the start and end of the current work week is.</p>
  
  <p>Is there a formula that can find this?</p>
  
  <p>Similarly:</p>
  
  <p>Is there also a similar method to automate the first and last days of the current month in different cells?</p>
  
  <p>Thank you ahead of time for any assistance</p>