If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formula to determine Fiscal Year
I have the customers start date in Column A, i.e. 4/1/2007.
In Column B I would like to determine what fiscal year they started in. For example: If their start date is between 3/1/08 - 2/28/09, I would like the result of Column B to be FY08/09. If their start date is between 3/1/07 - 2/28/08, I would like the result of Column B to be FY07/08. Is there a formula for this? |
#2
|
|||
|
|||
Formula to determine Fiscal Year
So, what happens if their start date is between 3/1/08 and 2/28/08 ?
You have an overlap on your two ranges. Pete On Dec 11, 12:55*pm, sa2960 wrote: I have the customers start date in Column A, i.e. 4/1/2007. In Column B I would like to determine what fiscal year they started in. For example: If their start date is between 3/1/08 - 2/28/09, I would like the result of Column B to be FY08/09. If their start date is between 3/1/07 - 2/28/08, I would like the result of Column B to be FY07/08. Is there a formula for this? |
#3
|
|||
|
|||
Formula to determine Fiscal Year
I'm not seeing the overlap. Our fiscal year starts March 1 of one year and
ends February 28 of the following year "Pete_UK" wrote: So, what happens if their start date is between 3/1/08 and 2/28/08 ? You have an overlap on your two ranges. Pete On Dec 11, 12:55 pm, sa2960 wrote: I have the customers start date in Column A, i.e. 4/1/2007. In Column B I would like to determine what fiscal year they started in. For example: If their start date is between 3/1/08 - 2/28/09, I would like the result of Column B to be FY08/09. If their start date is between 3/1/07 - 2/28/08, I would like the result of Column B to be FY07/08. Is there a formula for this? |
#4
|
|||
|
|||
Formula to determine Fiscal Year
Assuming real dates in A2 down,
try something like this in say, B2, copied down: =IF(AND(A2=--"01Mar2008",A2=--"28Feb2009"),"FY08/09", IF(AND(A2=--"01Mar2007",A2=--"28Feb2008"),"FY07/08","")) -- Max Singapore http://savefile.com/projects/236895 Downloads:21,000 Files:365 Subscribers:65 xdemechanik --- "sa2960" wrote: I'm not seeing the overlap. Our fiscal year starts March 1 of one year and ends February 28 of the following year |
Thread Tools | |
Display Modes | |
|
|