Solved

Current Fiscal Year - Calculated column

Posted on 2014-02-19
4
1,275 Views
Last Modified: 2014-02-24
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.
0
Comment
Question by:Isaac
  • 2
4 Comments
 
LVL 11

Expert Comment

by:Technodweeb
ID: 39872094
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?
0
 
LVL 11

Accepted Solution

by:
Technodweeb earned 400 total points
ID: 39872130
FiscalYear ==> =IF(MONTH(A2)>=10,YEAR(A2)+1,YEAR(A2))

Here is one for Excel. I attached a sample spreadsheet.
Current-Fiscal-Year---Calculated.xlsx
0
 
LVL 5

Author Comment

by:Isaac
ID: 39872167
SharePoint column but I think if it works in excel, it will work in SharePoint calculated column.

Thanks!
0
 
LVL 50

Assisted Solution

by:barry houdini
barry houdini earned 100 total points
ID: 39873094
This will also work in Excel

=YEAR(A2+92)

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
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question