Amazing Flash Fill Feature In Excel 2013 - How It Works? (10 examples) - (Topic 1/2)

Finally, the preview version of MS Office 2013 is out. Obviously, we would be more interest in visiting our lovely MS Excel 2013 preview. You can download the MS Excel 2013 preview from here. See the snaps of MS Excel 2013 here.

Since I heard about Flash Fill feature in MS Excel 2013 much earlier, immediately after opens the Excel preview I first tested Flash Fill feature. After experienced the Flash Fill option performance in Excel 2013, I can simply say that the trailer is bumper hit !!! One scene of Flash Fill Option in the trailer is sufficient to make the movie super hit.

Formula To Convert Date To Financial Year In MS Excel (07-Feb-1987 = FY 1986-87)

Today one of my friend asked me, the Formula to converts Date into Financial Year in MS Excel. I thought it is better to explain the same in my blog for the interest of other visitors.

Financial Year is 12 Months period which usually the Company follows according to their Accounting Policy. Here, I am going to explain you the Formula for the Financial Year which starts from the 1st Day of April Month and ends on 31st Day of March Month in the Following Year.

For Example, the Financial Year of 04 February, 2012 is 2011-12

Formula :

=IF(MONTH(A1)>3,"FY "&YEAR(A1)&"-"&RIGHT(YEAR(A1)+1,2),"FY "&YEAR(A1)-1&"-"&RIGHT(YEAR(A1),2))

Functions used in the Formula?