southwoman
New Member
Hi all
I hope you can help me with this question
I have the following date convention:
31 Mar 13
but I need to create two formulas that will firstly:
create the YEAR in this FORMAT: 2012.13
and then the quarter TO BE Q4
or alternately 1 formula to create 2012.13 Q4
Any ideas will be immensely appreciated
Regards
Nicole
I hope you can help me with this question
I have the following date convention:
31 Mar 13
but I need to create two formulas that will firstly:
create the YEAR in this FORMAT: 2012.13
and then the quarter TO BE Q4
or alternately 1 formula to create 2012.13 Q4
Any ideas will be immensely appreciated
Regards
Nicole