Spreadsheet: 782497d1654082584-calendar-formulas-update-for-53-week-years-tracker-wa
Sheet: FY Data

13 Period Day Count | Week No | Period | Period Start Date | Year 19/20 | Period Start Date | Year 20/21 | Period Start Date | Year 21/22 |  | Key | FY | start(test day) | end | remaining | 13 Period Calulator | Week Calulator | Financial year Calulator |  |  | Input Date | Period | Week Number | Year (FY)
7 | 1 | 1 | 2019-04-01 00:00:00 | 2019/20 | 2020-04-06 00:00:00 | 2020/21 | 2021-04-05 00:00:00 | 2021/22 |  | 2010 | 2010/11 | 2022-04-04 00:00:00 | 245
14 | 2 | 1 | 2019-04-08 00:00:00 | 2019/20 | 2020-04-13 00:00:00 | 2020/21 | 2021-04-12 00:00:00 | 2021/22 |  | 2011 | 2011/12
21 | 3 | 1 | 2019-04-15 00:00:00 | 2019/20 | 2020-04-20 00:00:00 | 2020/21 | 2021-04-19 00:00:00 | 2021/22 |  | 2012 | 2012/13
28 | 4 | 1 | 2019-04-22 00:00:00 | 2019/20 | 2020-04-27 00:00:00 | 2020/21 | 2021-04-26 00:00:00 | 2021/22 |  | 2013 | 2013/14
35 | 5 | 2 | 2019-04-29 00:00:00 | 2019/20 | 2020-05-04 00:00:00 | 2020/21 | 2021-05-03 00:00:00 | 2021/22 |  | 2014 | 2014/15
42 | 6 | 2 | 2019-05-06 00:00:00 | 2019/20 | 2020-05-11 00:00:00 | 2020/21 | 2021-05-10 00:00:00 | 2021/22 |  | 2015 | 2015/16
49 | 7 | 2 | 2019-05-13 00:00:00 | 2019/20 | 2020-05-18 00:00:00 | 2020/21 | 2021-05-17 00:00:00 | 2021/22 |  | 2016 | 2016/17
56 | 8 | 2 | 2019-05-20 00:00:00 | 2019/20 | 2020-05-25 00:00:00 | 2020/21 | 2021-05-24 00:00:00 | 2021/22 |  | 2017 | 2017/18
63 | 9 | 3 | 2019-05-27 00:00:00 | 2019/20 | 2020-06-01 00:00:00 | 2020/21 | 2021-05-31 00:00:00 | 2021/22 |  | 2018 | 2018/19
70 | 10 | 3 | 2019-06-03 00:00:00 | 2019/20 | 2020-06-08 00:00:00 | 2020/21 | 2021-06-07 00:00:00 | 2021/22 |  | 2019 | 2019/20
77 | 11 | 3 | 2019-06-10 00:00:00 | 2019/20 | 2020-06-15 00:00:00 | 2020/21 | 2021-06-14 00:00:00 | 2021/22 |  | 2020 | 2020/21
84 | 12 | 3 | 2019-06-17 00:00:00 | 2019/20 | 2020-06-22 00:00:00 | 2020/21 | 2021-06-21 00:00:00 | 2021/22 |  | 2021 | 2021/22
91 | 13 | 4 | 2019-06-24 00:00:00 | 2019/20 | 2020-06-29 00:00:00 | 2020/21 | 2021-06-28 00:00:00 | 2021/22 |  | 2022 | 2022/23
98 | 14 | 4 | 2019-07-01 00:00:00 | 2019/20 | 2020-07-06 00:00:00 | 2020/21 | 2021-07-05 00:00:00 | 2021/22 |  | 2023 | 2023/24
105 | 15 | 4 | 2019-07-08 00:00:00 | 2019/20 | 2020-07-13 00:00:00 | 2020/21 | 2021-07-12 00:00:00 | 2021/22 |  | 2024 | 2024/25
112 | 16 | 4 | 2019-07-15 00:00:00 | 2019/20 | 2020-07-20 00:00:00 | 2020/21 | 2021-07-19 00:00:00 | 2021/22 |  | 2025 | 2025/26
119 | 17 | 5 | 2019-07-22 00:00:00 | 2019/20 | 2020-07-27 00:00:00 | 2020/21 | 2021-07-26 00:00:00 | 2021/22 |  | 2026 | 2026/27
126 | 18 | 5 | 2019-07-29 00:00:00 | 2019/20 | 2020-08-03 00:00:00 | 2020/21 | 2021-08-02 00:00:00 | 2021/22 |  | 2027 | 2027/28
133 | 19 | 5 | 2019-08-05 00:00:00 | 2019/20 | 2020-08-10 00:00:00 | 2020/21 | 2021-08-09 00:00:00 | 2021/22 |  | 2028 | 2028/29
140 | 20 | 5 | 2019-08-12 00:00:00 | 2019/20 | 2020-08-17 00:00:00 | 2020/21 | 2021-08-16 00:00:00 | 2021/22 |  | 2029 | 2029/30
147 | 21 | 6 | 2019-08-19 00:00:00 | 2019/20 | 2020-08-24 00:00:00 | 2020/21 | 2021-08-23 00:00:00 | 2021/22 |  | 2030 | 2030/31
154 | 22 | 6 | 2019-08-26 00:00:00 | 2019/20 | 2020-08-31 00:00:00 | 2020/21 | 2021-08-30 00:00:00 | 2021/22
161 | 23 | 6 | 2019-09-02 00:00:00 | 2019/20 | 2020-09-07 00:00:00 | 2020/21 | 2021-09-06 00:00:00 | 2021/22
168 | 24 | 6 | 2019-09-09 00:00:00 | 2019/20 | 2020-09-14 00:00:00 | 2020/21 | 2021-09-13 00:00:00 | 2021/22
175 | 25 | 7 | 2019-09-16 00:00:00 | 2019/20 | 2020-09-21 00:00:00 | 2020/21 | 2021-09-20 00:00:00 | 2021/22
182 | 26 | 7 | 2019-09-23 00:00:00 | 2019/20 | 2020-09-28 00:00:00 | 2020/21 | 2021-09-27 00:00:00 | 2021/22
189 | 27 | 7 | 2019-09-30 00:00:00 | 2019/20 | 2020-10-05 00:00:00 | 2020/21 | 2021-10-04 00:00:00 | 2021/22
196 | 28 | 7 | 2019-10-07 00:00:00 | 2019/20 | 2020-10-12 00:00:00 | 2020/21 | 2021-10-11 00:00:00 | 2021/22
203 | 29 | 8 | 2019-10-14 00:00:00 | 2019/20 | 2020-10-19 00:00:00 | 2020/21 | 2021-10-18 00:00:00 | 2021/22
210 | 30 | 8 | 2019-10-21 00:00:00 | 2019/20 | 2020-10-26 00:00:00 | 2020/21 | 2021-10-25 00:00:00 | 2021/22
217 | 31 | 8 | 2019-10-28 00:00:00 | 2019/20 | 2020-11-02 00:00:00 | 2020/21 | 2021-11-01 00:00:00 | 2021/22
224 | 32 | 8 | 2019-11-04 00:00:00 | 2019/20 | 2020-11-09 00:00:00 | 2020/21 | 2021-11-08 00:00:00 | 2021/22
231 | 33 | 9 | 2019-11-11 00:00:00 | 2019/20 | 2020-11-16 00:00:00 | 2020/21 | 2021-11-15 00:00:00 | 2021/22
238 | 34 | 9 | 2019-11-18 00:00:00 | 2019/20 | 2020-11-23 00:00:00 | 2020/21 | 2021-11-22 00:00:00 | 2021/22
245 | 35 | 9 | 2019-11-25 00:00:00 | 2019/20 | 2020-11-30 00:00:00 | 2020/21 | 2021-11-29 00:00:00 | 2021/22
252 | 36 | 9 | 2019-12-02 00:00:00 | 2019/20 | 2020-12-07 00:00:00 | 2020/21 | 2021-12-06 00:00:00 | 2021/22
259 | 37 | 10 | 2019-12-09 00:00:00 | 2019/20 | 2020-12-14 00:00:00 | 2020/21 | 2021-12-13 00:00:00 | 2021/22
266 | 38 | 10 | 2019-12-16 00:00:00 | 2019/20 | 2020-12-21 00:00:00 | 2020/21 | 2021-12-20 00:00:00 | 2021/22
273 | 39 | 10 | 2019-12-23 00:00:00 | 2019/20 | 2020-12-28 00:00:00 | 2020/21 | 2021-12-27 00:00:00 | 2021/22
280 | 40 | 10 | 2019-12-30 00:00:00 | 2019/20 | 2021-01-04 00:00:00 | 2020/21 | 2022-01-03 00:00:00 | 2021/22
287 | 41 | 11 | 2020-01-06 00:00:00 | 2019/20 | 2021-01-11 00:00:00 | 2020/21 | 2022-01-10 00:00:00 | 2021/22
294 | 42 | 11 | 2020-01-13 00:00:00 | 2019/20 | 2021-01-18 00:00:00 | 2020/21 | 2022-01-17 00:00:00 | 2021/22
301 | 43 | 11 | 2020-01-20 00:00:00 | 2019/20 | 2021-01-25 00:00:00 | 2020/21 | 2022-01-24 00:00:00 | 2021/22
308 | 44 | 11 | 2020-01-27 00:00:00 | 2019/20 | 2021-02-01 00:00:00 | 2020/21 | 2022-01-31 00:00:00 | 2021/22
315 | 45 | 12 | 2020-02-03 00:00:00 | 2019/20 | 2021-02-08 00:00:00 | 2020/21 | 2022-02-07 00:00:00 | 2021/22
322 | 46 | 12 | 2020-02-10 00:00:00 | 2019/20 | 2021-02-15 00:00:00 | 2020/21 | 2022-02-14 00:00:00 | 2021/22
329 | 47 | 12 | 2020-02-17 00:00:00 | 2019/20 | 2021-02-22 00:00:00 | 2020/21 | 2022-02-21 00:00:00 | 2021/22
336 | 48 | 12 | 2020-02-24 00:00:00 | 2019/20 | 2021-03-01 00:00:00 | 2020/21 | 2022-02-28 00:00:00 | 2021/22
343 | 49 | 13 | 2020-03-02 00:00:00 | 2019/20 | 2021-03-08 00:00:00 | 2020/21 | 2022-03-07 00:00:00 | 2021/22
350 | 50 | 13 | 2020-03-09 00:00:00 | 2019/20 | 2021-03-15 00:00:00 | 2020/21 | 2022-03-14 00:00:00 | 2021/22
357 | 51 | 13 | 2020-03-16 00:00:00 | 2019/20 | 2021-03-22 00:00:00 | 2020/21 | 2022-03-21 00:00:00 | 2021/22
364 | 52 | 13 | 2020-03-23 00:00:00 | 2019/20 | 2021-03-29 00:00:00 | 2020/21 | 2022-03-28 00:00:00 | 2021/22
Week 53 is not included |  |  | 2020-03-30 00:00:00 | 2019/20