LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
PatK
 
Posts: n/a
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
months between 2 dates!!! speary Excel Discussion (Misc queries) 1 August 19th 05 03:22 PM
Why "datedif" function results sometimes negative numbers? Ambrosiy Excel Worksheet Functions 1 July 8th 05 11:29 AM
Date formula: return Quarter and Fiscal Year of a date Rob Excel Discussion (Misc queries) 7 May 11th 05 08:48 PM
How do i change 15 months to read 1 year and 3 months? Marty Excel Discussion (Misc queries) 1 February 17th 05 11:21 PM
Fiscal year total from running 12 months Excel Worksheet Functions 2 February 9th 05 12:11 AM


All times are GMT +1. The time now is 06:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"