Financial/Fiscal Year

[c_Dr_ysdale]

Hi, on the back of another thread I would like to use the similar formula =IF(MONTH(A4)>9,YEAR(A4)&"-"&RIGHT(YEAR(A4)+1,2),YEAR(A4)-1&"-"&RIGHT(YEAR(A4),2))

However my financial year runs slightly different, for example:

Q1 = 1/10/2013 - 31/12/2013
Q2 = 1/1/2014 - 31/3/2014
Q3 = 1/4/2014 - 30/6/2014
Q4 = 1/7/2014 - 30/9/2014

I have been trying to change the formula to match my financial year, but i am struggling - probably already in christmas holiday mode - but could someone please help?

Thanks!

 

[Andrew Poulsom]

In what way doesn't that formula work for you?

 

[c_Dr_ysdale]

so for example, if i enter the dates in the left column, i would imagine the outcome to be 2014-2015 as that is the new financial year i am currently in. However it keeps coming out as 2013-2014...

[TABLE="width: 207"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Date[/TD]
[TD]Financial Year
[/TD]
[/TR]
[TR]
[TD="align: right"]01-03-14[/TD]
[TD]2013-14[/TD]
[/TR]
[TR]
[TD="align: right"]01-02-14[/TD]
[TD]2013-14[/TD]
[/TR]
[TR]
[TD="align: right"]01-02-14[/TD]
[TD]2013-14[/TD]
[/TR]
[TR]
[TD="align: right"]01-02-14[/TD]
[TD]2013-14[/TD]
[/TR]
[TR]
[TD="align: right"]01-01-14[/TD]
[TD]2013-14[/TD]
[/TR]
[TR]
[TD="align: right"]01-01-14[/TD]
[TD]2013-14[/TD]
[/TR]
[TR]
[TD="align: right"]01-12-13[/TD]
[TD]2013-14[/TD]
[/TR]
[TR]
[TD="align: right"]01-12-13[/TD]
[TD]2013-14[/TD]
[/TR]
[TR]
[TD="align: right"]01-12-13[/TD]
[TD]2013-14[/TD]
[/TR]
[TR]
[TD="align: right"]01-12-13[/TD]
[TD]2013-14[/TD]
[/TR]
[TR]
[TD="align: right"]01-12-13[/TD]
[TD]2013-14[/TD]
[/TR]
[TR]
[TD="align: right"]01-12-13[/TD]
[TD]2013-14[/TD]
[/TR]
[TR]
[TD="align: right"]01-11-13[/TD]
[TD]2013-14[/TD]
[/TR]
[TR]
[TD="align: right"]01-11-13[/TD]
[TD]2013-14[/TD]
[/TR]
[TR]
[TD="align: right"]01-11-13[/TD]
[TD]2013-14[/TD]
[/TR]
[TR]
[TD="align: right"]01-11-13[/TD]
[TD]2013-14[/TD]
[/TR]
[TR]
[TD="align: right"]01-10-13[/TD]
[TD]2013-14[/TD]
[/TR]
[TR]
[TD="align: right"]01-10-13[/TD]
[TD]2013-14[/TD]
[/TR]
[TR]
[TD="align: right"]01-10-13[/TD]
[TD]2013-14[/TD]
[/TR]
[TR]
[TD="align: right"]01-10-13[/TD]
[TD]2013-14[/TD]
[/TR]
</tbody>[/TABLE]

 

[Andrew Poulsom]

How can you be in 2014-15? We haven't reached 2014 yet.

 

[c_Dr_ysdale]

That's just how our financial year runs within my company? Our financial year runs from October to September, so now we are in our financial year 2014.

I take it by your responses that you can't do this then?

 

[Andrew Poulsom]

Sorry, how can it be 2014-15 when it ends in September 2014? Do you want 2014 returned?

=YEAR(A4)+(MONTH(A4)>9)

 

[barry houdini]

If you just want the year try

=YEAR(A4+92)

 

[c_Dr_ysdale]

Thanks Barry! That worked fine.