title: Converting text to date format YYQQ
body: <p>I am storing project start and finish dates in the text format YYQQ. My goal is to convert this text to an actual date format, as to be able to substract finish and start dates to obtain the duration of a project in number of quarters.</p>
  
  <p>For example if a project started in the third quarter of 2015, 15Q3 and finished in the second quarter of 2016, 16Q2, then it took 3 quarters to complete the project.</p>
  
  <p>The excel function DATE requires text to be converted to the format YYMMDD, which is not what I want. Does excel have a function to convert for example text 16Q2 to date YYQQ format?</p>