The VBA function as defined in 06:26 of this video may not be taking the valid approach. I think the function should be redefined as follows:

Public Function MyFiscalYear(DateIn As Date) As Integer

    MyFiscalYear = Year(DateIn)
    
    If Month(DateIn) > 5 Then
       MyFiscalYear = MyFiscalYear + 1
    End If

End Function

This way, if the fiscal year BEGINS on June 1st, 2012, then you are STARTING fiscal year 2013.

---

Reply from Richard Rost:

Bruce, that is a perfectly valid argument. It all depends on your needs and when your fiscal year starts. I've had clients who had their fiscal year 2012 run from 6/1/11 to 5/31/12, and I've had others that defined FY 2012 as 6/1/12 to 5/31/13. It's all up to you and how you want to define it for your business.

The Federal Government, for example uses a FY that ENDS in the current year, so FY 2013 is from October 1 2012 through September 30 2013. It runs from October 1 of the PRIOR year through Sept 30 of the current year.