Retail & 4-4-5 Fiscal Calendars in Excel: Fiscal Weeks, Periods, 53-Week Years, Comparable Weeks & Weekly Sales Reports

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Apply Hollins & Pike's calendar rule to find the first Sunday of seven fiscal years, show each start date as text and turn any date into its fiscal week and day in the week.
• Build the last week of every period for the three quarter patterns, then find the quarter and the period of eight fiscal weeks by formula, so any weekly figure can be rolled up into periods.
• Measure every fiscal year from its start to the next start, find the Saturday it ends on, flag the 53-week years and give period 12 its extra week.
• Tag 26 days of one store's sales with their fiscal week, sum them per week with SUMIFS on the week's dates, average them per trading day and flag the week that is not complete yet.
• Compare FY2030's first 13 weeks with FY2029 week by week, see why the comparison is off after a 53-week year, restate last year by one week and measure the real 13-week growth.
• Locate a moving spring holiday in last year's and this year's fiscal calendar, flag both holiday weeks, see how the shift distorts weekly growth and measure growth with the holiday weeks aligned.
• For report week 19 you find the period, add up period-to-date and year-to-date sales with SUMIFS, compare them with last year and with the plan, so the numbers move on automatically when the report week changes.
• Build Hollins & Pike's Q1 trading report: weekly growth vs last year, a periods table with SUMIFS, a 13-week trend chart of this year against last year and a red flag on every week below last year.