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:
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.