Fiscal Quarters

  • Thread starter Thread starter Mike S.
  • Start date Start date
M

Mike S.

Microsoft, in its knowledge base, has provided functions
for calculating fiscal years and fiscal months which may
vary by the beginning month and day of a fiscal year.
Would anyone know how to adapt the functions in order to
calculate a fiscal quarter?
 
The fiscal quarter of the field MyDate would be:
DatePart("q", DateAdd("m", 6, [MyDate]))
 
Back
Top