What is the easiest way to convert quarter notation "yyyyq1" "yyyyq4" into proper Excel dates? We can assume e.g. that 1999q2 means 1st April 1999.
Perhaps simplify the month part.....



You can use the formula:
The first part 

