Fiscal Calendar

[hayesla96]

I am trying to build a fiscal calendar that can be used as a template for all reports. However, I don't know how to build this all the way back to 1999. 

Period	Month End	Weeks	Days
2018	12/30/2018
2019
1	1/27/2019	4	28
2	3/3/2019	5	35
3	3/31/2019	4	28
4	4/28/2019	4	28
5	6/2/2019	5	35
6	6/30/2019	4	28
7	7/28/2019	4	28
8	9/1/2019	5	35
9	9/29/2019	4	28
10	10/27/2019	4	28
11	12/1/2019	5	35
12	12/29/2019	4	28
		52	364
2020
1	1/26/2020	4	28
2	3/1/2020	5	35
3	3/29/2020	4	28
4	4/26/2020	4	28
5	5/31/2020	5	35
6	6/28/2020	4	28
7	7/26/2020	4	28
8	8/30/2020	5	35
9	9/27/2020	4	28
10	10/25/2020	4	28
11	11/29/2020	5	35
12	12/27/2020	4	28
		52	364
2021
1	1/24/2021	4	28
2	2/28/2021	5	35
3	3/28/2021	4	28
4	4/25/2021	4	28
5	5/30/2021	5	35
6	6/27/2021	4	28
7	7/25/2021	4	28
8	8/29/2021	5	35
9	9/26/2021	4	28
10	10/24/2021	4	28
11	11/28/2021	5	35
12	1/2/2022	5	35
		53	371

[v-shex-msft]

Hi @hayesla96,

I'm not so clear about your requirement,  can you please share some dummy data with a similar data structure and expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng