We need a little help also, please explain what problem(s) you are having
with which formula. What, if any, relationship does either formula have to
do with the other (i.e., is the first formula given a name that is used in
the second one like maybe Per_1_End_Date ?).

What error are you getting? One thing that might help you to diagnose the
problem is to take each one of the Choose options and put them in individual
cells to see what each is calculating at any given time.

"need help pls" wrote:

hi people...doing a finance assignment using an excel model...just struggling
abit with some of the formulas - any input is appreciated:


=EOMONTH(DATE(YEAR(Model_Start_Date)+1*(MONTH(Mode l_Start_Date)MATCH(Per_1_End_Mth,LU_Mths,0)),MATC H(Per_1_End_Mth,LU_Mths,0),1),0)


=CHOOSE(DD_Model_Per_Type,
Yr_Name,
IF(MONTH(Per_1_End_Date)=DD_Fin_YE_Mth,Half_2,
Half_1),
IF(MONTH(Per_1_End_Date)=DD_Fin_YE_Mth,Qtr_4,
IF(ABS(MONTH(Per_1_End_Date)-DD_Fin_YE_Mth)=Mths_In_Half_Yr,Qtr_2,
IF(OR(MONTH(Per_1_End_Date)-DD_Fin_YE_Mth=-Mths_In_Qtr,MONTH(Per_1_End_Date)-DD_Fin_YE_Mth=3*Mths_In_Qtr),Qtr_3,
Qtr_1))),
"M"&MONTH(Per_1_End_Date)-DD_Fin_YE_Mth+(DD_Fin_YE_Mth=MONTH(Per_1_End_Date ))*Mths_In_Yr)

thanks heaps