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