Calendar/Date help

Hi rp2022 ,

Thanks for reaching out.

I almost understand your requirement, but I still have doubts about your last two rows.

How does the New Week and Reporting Date calculate? 

Why did the New Week change from 1 to 2 and the Reporting Date from 11/1/2024 to 11/2/2024 and 11/4/2024?

Best Regards,
Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly