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.
Take the 2minute tour
×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
Perhaps simplify the month part.....



You can use the formula:
The first part 

