| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
display quarter and fiscal year
I would like to be able to identify the quarter and fiscal
year of any given date of the year. Also our fiscal years start in July. So for example, any date from Jul 1,2004 to Sep 30,2004 = FY05 Q1, Oct 1,2004 to Dec 31,2004 = FY05 Q2, Jan 1,2005 to Mar 31,2005 = FY05 Q3, and so on.... Thanks in advance for your help. Kind regards, D S K |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert a specific date to a fiscal quarter ? | Excel Discussion (Misc queries) | |||
| Fiscal Quarter Conversion | Excel Worksheet Functions | |||
| fiscal quarter conversion | Excel Discussion (Misc queries) | |||
| fiscal quarter data validation | Excel Worksheet Functions | |||
| Date formula: return Quarter and Fiscal Year of a date | Excel Discussion (Misc queries) | |||
Threaded Mode
