Convert quarter-year to MM/DD/YYYY in Excel

Question

How to convert this quarter-year format into MM/DD/YYYY in Excel where quarter will convert to first day of quarter. For example, Q1-2014 to 1/1/2014, Q2-2015 to 4/1/2015, Q3-2016 to 7/1/2016, Q4-2017 to 10/1/2017

Answer 1

Try

=DATE(RIGHT(A1,4),(MID(A1,2,1)*3)-2,1)

That will return a date. Format to display in whatever date format you want.