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?

How To Extract Characters From Text String by Using RIGHT Formula?

RIGHT is one of the Most Useful Text Formula in MS Excel. RIGHT returns the Last Character or Characters in a Text String, based on the number of characters you specify.


The Syntax for the RIGHT function is
 =RIGHT(text,[num_chars])

How To Extract Characters From Text String by Using LEFT Formula?

LEFT is one of the Most Useful Text Formula in MS Excel. LEFT returns the first character or characters in a text string, based on the number of characters you specify.


The Sytax for the LEFT function is
 =LEFT(text,[num_chars])

This is the formula to change DD.MM.YY format to MM-DD-YY

   The following is the simple formula to change the DD.MM.YY Date Format to MM-DD-YY. In 2007 and above excel versions you can change the same through the Format Option (Right Click, Format, under Number tab, click Date).


But you can't use the DD.MM.YY format in 2003 and below Excel versions for different date formats. For that you need to first change the date format to MM-DD-YY then use the format option for different date formats.