I am using a date in an exported file; I want to convert it to an Excel recognizable format and basically add three quarters to it so it will reflect the quarter end date three quarters away.
For example:
Cell A1:20121128
I want Cell A2 to return: 09/30/2013
(Cell A1's quarter ending date...