Turning Calendar month into Fiscal Year problem

**baby_mic** · 03-18-2010, 10:21 AM

Hello,

I also have a problem with an "if" formula. As you can see in attached sample, i have a range of months, and I extracted the year using a MID formula. However, in our company the Fiscal Year begins in October, so 200710 should already be 08, 200810 - 09, and so on. How could I introduce an "if" formula (or something else), so that I can turn months into FY?

Many thanks in advance for your help.

**arthurbr** · 03-18-2010, 10:31 AM

Hi and welcome to the board
I don't quite follow your logic. Could you please enter a few examples in your sheet of what you want to obtain?

**baby_mic** · 03-18-2010, 10:59 AM

Thank you for your interest in my problem.

I added some examples to my file, I hope I managed to be more specific and clear this time.

**JeanRage** · 03-18-2010, 12:36 PM

Hi,

Take a look at attached file ...

HTH

**arthurbr** · 03-19-2010, 04:34 AM

Hi,
if the result needs to stay as text try the following in G13 ( referring to your posted sheet)
=IF(RIGHT(F13,2)*1>=10,CONCATENATE(LEFT(F13,4)+1,RIGHT(F13,2)),F13&"")