# Calculations based on 4-4-5 fiscal calendar

Question asked by comment on Mar 14, 2019
Latest reply on Mar 14, 2019 by comment

This is a spin-off from:

I have decided to open a new thread since the last question posted is significantly different from the original topic.

The request is to calculate the fiscal year, fiscal quarter and fiscal week of a given date, based on the following rules:

• The fiscal year is based on the 4–4–5 calendar; this divides a year into four quarters of 13 weeks each (with a 53rd week added every five or six years):
• The fiscal year always ends on the last Saturday in April.

OP posted the following example for the fiscal year of 2019:

 Month # Weeks Start End May 4 29-Apr-18 26-May-18 June 4 27-May-18 23-Jun-18 July 5 24-Jun-18 28-Jul-18 August 4 29-Jul-18 25-Aug-18 September 4 26-Aug-18 22-Sep-18 October 5 23-Sep-18 27-Oct-18 November 4 28-Oct-18 24-Nov-18 December 4 25-Nov-18 22-Dec-18 January 5 23-Dec-18 26-Jan-19 February 4 27-Jan-19 23-Feb-19 March 4 24-Feb-19 23-Mar-19 April 5 24-Mar-19 27-Apr-19