How to calculate week ending

[Shawry]

Hi, 

I have a Week Ending formula to calculate the week ending date (ending on a Sunday). However, I've come across a problem when dealing with a Sunday. You'll see in my table that when the row is in fact a Sunday, it includes that in the following week. 

For example, you'll see that the 5th of March (which is a Sunday) is included in the following week i.e. Week Ending = 12th Sunday. 

Does anyone know how I would resolve this? 

Thanks!

[Ahmedx · Accepted solution]

g

week Ending=[Date]-WEEKDAY([Date],2)+7

[Shawry]

Thank you 🙂