Abbydale Systems LLC - ExcelFYInfo

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.

*** U p d a t e ***

The functions now support the date being passed as an Excel format integer date.

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 here 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. By default the start month for the financial year is October (Month 10) is is mainly because that is when our finanical 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 as the month to start the financial year
FYWeekNumber = FYWeek("10/8/2021")
FYPeriodNumber = FYPeriod("10/8/2021")

The demostration below shows how to use these functions in a cell.

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.

Last modified : Tuesday 22nd of November 2022