Define the function Quarter to be used in your Excel

[adyteo]

You could create an add-in (".xla"), that you load it every time you open excel, with formulas you use often that are not defined by Microsoft but by you.

e.g. function Quarter(date, type)

What the below code does is to take the date and convert it into a string with a certain format:
if type is 0, then it will be e.g. CY14Q1
if type is 1, then it will be e.g. FY14Q1

Please Login or Register  to view this content.

Good luck