How to: |
The FIQTR function will determine the financial quarter corresponding to a given calendar date.
FIYR(inputdate, lowcomponent, startmonth, startday, yrnumbering, result)
where:
Numeric
Alphanumeric
Is one of the following:
Numeric
1-12 is used to represent a financial year starting in January and going to December.
Numeric
1, or another starting day in the starting month.
Alphanumeric
FYE or FYS is used.
Numeric
The result will be in integer format, or Q. This function will return a value of 1-4.
iWay Software |