5-4-4 Financial Calendar with months overlapping calendar months
We have a 5-4-4 Financial calendar that can span calendar years and months. This is the schedule for 2020:
FY = 29-Dec-2019 to 26-Dec-2020
M1 = 29-Dec-2019 to 01-Feb-2020
M2 = 02-Feb-2020 to 29-Feb-2020
M3 = 01-Mar-2020 to 28-Mar-2020
M4 = 29-Mar-2020 to 02-May-2020
etc etc. Note the weeks go in 5-4-4 blocks and 35-28-28 day blocks.
I need to be able to compare my data for complete weeks only, so for example "Year to date to the end of last week", to "last year to date to the end of the same date the previous year" (offset of course).
LIkewise, the same with Months and Quarters.
Its getting very tricky and beyond my scope of knowledge - does anyone know if this is possible please, and if so how?
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.