How do I convert a text data (ex. 10Q1, 10Q2, 10Q3) into a Date (ex. Jan 2010)?
I am facing the challenge of converting a quarterly sales forecast into a monthly forecast.
The report has a project starting date (in 10Q1, 10Q2, 10Q3..) and an estimated annual usage. By dividing the annual usage by 12, I get the monthly usage.
But how do I convert "10Q1" into "Jan 2010"? "10Q2" into "April 2010"? and "10Q3" into "July 2010"?
Is there a way I can have them automatically populate the attached format?