Please Read the whole Explanation to understand better.
Below is the Excel formula for getting Fiscal Year for the date you want in the formulated cell.
=Year(Date(Year(cell),Month(cell)+9,1))
Cell : Cell in the above formula refers to the cell containing the date for which we want the fiscal year.
The above formula is for fiscal year from 1 apr - 31 mar.
After month we have added 9 because after march i.e. last month of our fiscal year there are more 9 months left to complete the celander year.
Below is the Excel formula for getting Fiscal Year for the date you want in the formulated cell.
=Year(Date(Year(cell),Month(cell)+9,1))
Cell : Cell in the above formula refers to the cell containing the date for which we want the fiscal year.
The above formula is for fiscal year from 1 apr - 31 mar.
After month we have added 9 because after march i.e. last month of our fiscal year there are more 9 months left to complete the celander year.
No comments:
Post a Comment