Current Fiscal Year - Calculated column

How can I determine the current fiscal year using a calculated column?
The fiscal year falls within Oct and Sept of a given year.

So for this year, the fiscal year is Oct 2013 to Sept 2014

Thanks for any help you can provide.
IsaacSharePoint Client Side DeveloperAsked:
Who is Participating?
Gregory MillerConnect With a Mentor General ManagerCommented:
FiscalYear ==> =IF(MONTH(A2)>=10,YEAR(A2)+1,YEAR(A2))

Here is one for Excel. I attached a sample spreadsheet.
Gregory MillerGeneral ManagerCommented:
Are you wanting a calculation for a spreadsheet cell or for a column in a SharePoint column, or how exactly are you wanting to use this calculated result?
IsaacSharePoint Client Side DeveloperAuthor Commented:
SharePoint column but I think if it works in excel, it will work in SharePoint calculated column.

barry houdiniConnect With a Mentor Commented:
This will also work in Excel


It's 92 because your fiscal year is "offset" by 92 days from the regular calendar year - i.e. 1st October to 1st January is 92 days

regards, barry
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.