I have created a function that takes a date as its argument and I want it to return 3 values (month, Quarter, Financial Year).

The code itself works fine (I have tested it using msgboxes) However I need to actually return all 3 values, and I cannot see how to do this with a simple function.

Do I need to use Property Let/Get, or a class?

Thanks

Francis