• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Show Current week dates


New Member
hi Forum ,

I got struck with a problem showing the beginning & Ending of the week by dates.

For example, If i take Sunday today as the beginning of the week i.e. 04th April 2021 to 10th April 2021 (Saturday) as ending of the week.

I want the same to repeat for every week in a month in my excel sheet.

What is the formula that i could use to achieve the same..

Kindly Help.


Active Member
Please post a sample sheet showing some manually entered data so we can see the resulting layout you need