I used the formula listed here to generate a fiscal year based on the current month. I have an odd requirement where she wants the fiscal year to start on 6/20. For example, any dates ranging from 6/20/2014 to 6/19/2014 will Fiscal Year 15.

Can someone help me figure out the formula?

My formula is currently is:

`=IF(MONTH(J2)>=7,YEAR(J2)+1,YEAR(J2))`

Column J has the date that I need to calculate the fiscal year for.

So, I am close where anything from July (7) to December (12) will be calculated as the current year + 1.