Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there a way to define my own fiscal year that was different form the
normal calendar?I wanted the month to automatically appear when i enter the date. I know we can make use of the date function for a normal date, is there any formula or codes that i can define my own fiscal year? Here's the list of my fiscal year ; Date Month From 1/25/09 to 2/21/09 Feb From 10/19/08 to 11/22/08 Nov From 11/23/08 to 12/27/08 Dec From 12/28/08 to 1/24/09 Jan From 2/22/09 to 3/28/09 Mar From 3/29/09 to 4/25/09 Apr From 4/26/09 to 5/23/09 May From 5/24/09 to 6/27/09 Jun From 6/28/09 to 7/25/09 Jul From 7/26/09 to 8/22/09 Aug From 8/23/09 to 9/26/09 Sep From 9/21/08 to 10/18/08 Oct |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
fiscal year calculation | Excel Discussion (Misc queries) | |||
Fiscal Year Formula | Excel Discussion (Misc queries) | |||
calendar year versus fiscal year | Excel Discussion (Misc queries) | |||
Help dealing with a fiscal year rather than a calendar year | Excel Worksheet Functions | |||
Birthdate as fiscal year | Excel Discussion (Misc queries) |