Formating Fiscal Quarters, rather than Months
I would like to be able to format a date based upon fiscal quarter, rather
than simply Month year. This would be based upon the underlining data: For
example, what I would like to see:
Q1FY06 Q2FY06 Q3FY06 Q4FY06
Would be created by inputing:
11/1/2005 02/01/2005 05/01/2005 08/01/2005
Once formated they would show as above. Otherwise, I will define a named
field, and go that way, but I have a lot of these headings to do, and
formatting them would be simplest way to get them to work, if possible.
Is there any sort of custom formatting that would do this?
Thanks!
PatK
|