Excel formula to derive the financial year.

Dear all,


I am having dates in column B ( yyyy/mm/dd) and i need to get the financial year for tax purpose for the given date. For example, if the date is October 2nd, 2015 – then we would put “2015” in the “A” column. Similarly, if the date September 28th, 2015, then we would put “2014” in the “A” column. i.e. the Fiscal Year of the receipt/expense based on an October 1st to September 30th format. To summarize if the month is greater than or equal to "october" then we have to input the exact year present in col B, else we need to minus one from the year present in col b.

I have tried with the following fomulas, but its not working.

=IF((TEXT(B4,"m"))>=10,(TEXT(B4,"yyyy")))

=IF((TEXT(B3,"mm"))=10,(TEXT(B3,"yyyy")),IF((TEXT(B3,"mm"))=11,(TEXT(B3,"yyyy")),IF((TEXT(B3,"mm"))=12,(TEXT(B3,"yyyy")),(TEXT(B3,"yyyy")-1))))

Hence please help me on this.

thanks.

Thanks a lot for your swift quick answer... it worked... thanks a ton.