As ever, you use this free program at your own risk.
Feel free to use the free software on this site but please honor the copyright.
We have added another function, named FYValidateSAP, which will
validate and reformat the SAP date. The returned date will be in
mm/dd/yyyy format.
Invalid dates will produce an error message and the cell will be filled
with the value 911.
The Excel VBA code provided by clicking on the button below can be used to
give the value of the financial Year, the week of the financial year and
the period (relative month) of the financial year for a passed date.
By default the start month for the financial year is October (Month 10) is is mainly because that is when our financial year starts.
It should be noted that FYPeriod calls FYWeek so in order for FYPeriod to work FYWeek must be available.
If no date is passed to the routines the current date is used.
The functions can be used in either a spreadsheet cell or in VBA code. They can be called as follows:
- FYYear = FY("10/8/2021")
- FYYear = FY("10/8/2021",4)
This uses April (month 4) as the month to start the financial year - FYWeekNumber = FYWeek("10/8/2021")
- FYPeriodNumber = FYPeriod("10/8/2021")
This material has been used successfully by Abbydale Systems LLC. and to the best of our knowledge this material and any system(s) of which it is a part are operational as of the service level or date stated in the body of this material (if so stated). However, NO warranty is given or implied as to the accuracy of this material or any related material or systems, and no responsibility is assumed for any effect or modification directly or indirectly caused by the use of this material.
It is the responsibility of any user of this material to evaluate its usefulness to the user's environment.
Abbydale Systems LLC. does not guarantee to keep this or any related material current, nor does it guarantee to provide any corrections or extensions described by any users of this material or any corrections or extensions made in the future by Abbydale Systems LLC. itself.
