title: Excel formula for "one calendar month" to calculate deadline for GDPR responses
body: <p>I've been trying to create a formula in excel to calculate the deadline for a GDPR subject access response based on the date of the request.  Sounds simple??  The ICO description of how to calculate it is:-</p>
  
  <blockquote>
    <p>You should calculate the time limit from the day after you receive the request (whether the day after is a working day or not) until the corresponding calendar date in the next month.  If this is not possible because the following month is shorter (and there is no corresponding calendar date), the date for response is the last day of the following month.  If the corresponding date falls on a weekend or a public holiday, you have until the next working day to respond.  This means that the exact number of days you have to comply with a request varies, depending on the month in which the request was made."</p>
  </blockquote>
  
  <p>I just can't work out how to turn this into an excel formula and will probably just settle for [date]+28 unless someone can help me please?</p>
  
  <p>Best wishes,
  Tony</p>