This is one single document which contains close to 100 formulas dealing with various situations. Useful for Intermediate and Advanced users.
Download it from Excel - Formulas Bible
A good number of countries don't follow calendar year as the financial year. For example, India's financial year start is 1-Apr and finishes on 31-Mar. Hence, currently (20-Feb-16), the financial year is 2015-16 (It is also written as FY16). On 1-Apr-16, it will become 2016-17 (It is also written as FY17).
Now if a date is given, then following formula can be used to derive 2015-16 kind of result.
To generate FY16 kind of result, following formula can be used