Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
months between 2 dates!!! | Excel Discussion (Misc queries) | |||
Why "datedif" function results sometimes negative numbers? | Excel Worksheet Functions | |||
Date formula: return Quarter and Fiscal Year of a date | Excel Discussion (Misc queries) | |||
How do i change 15 months to read 1 year and 3 months? | Excel Discussion (Misc queries) | |||
Fiscal year total from running 12 months | Excel Worksheet Functions |