View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
obc1126 obc1126 is offline
external usenet poster
 
Posts: 9
Default My own fiscal year

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