[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
Solved

# Current Fiscal Year - Calculated column

Posted on 2014-02-19
Medium Priority
1,410 Views
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

0
Question by:Isaac
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 2

LVL 12

Expert Comment

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 12

Accepted Solution

Gregory Miller earned 1600 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

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

barry houdini earned 400 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

Question has a verified solution.

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

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.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
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 …
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
###### Suggested Courses
Course of the Month14 days, 1 hour left to enroll