Formula for Week Ending Dates but also stop at Fiscal Month End

[johnny51981]

I have a need to have a reporting calendar created.

My weekly reporting period Starts on Sundays and Ends on Saturdays. I am easily able to get this in as a formula.

However, our Fiscal Months run from the 22nd to the 21st.

What I would like to have is a formula that would give me every Friday Date as the Reporting End Date, but also give me the 21st as the Reporting End Date no matter what day of the week it lands.

Here is what I would like my desired results to look like:

Start Date	End Date
12/22/2021	12/25/2021
12/26/2021	1/1/2022
1/2/2022	1/8/2022
1/9/2022	1/15/2022
1/16/2022	1/21/2022
1/22/2022	1/22/2022
1/23/2022	1/29/2022

 

[Tetra201]

Maybe

=IF(AND(DAY(A2)>15,DAY(A2)<22,DAY(A2)-WEEKDAY(A2)>14),--TEXT(A2,"yyyy-mm-\2\1"),WORKDAY.INTL(A2-1,1,"1111101"))