Sahil Soni

Microsoft Excel Formulas:-
1. For Converting the Date into Financial Year: =IF(MONTH(A4)>3,YEAR(A4)&"-"&YEAR(A4)+1,YEAR(A4)-1&"-"&YEAR(A4))
2. For classifying the date as Quarters : =IF(MONTH(A4)<=3,"Q4_Jan-Mar",IF(MONTH(A4)<=6,"Q1_Apr-Jun",IF(MONTH(A4)<=9,"Q2_Jul-Sep","Q3_Oct-Dec")))