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
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.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.