MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Week ending date as a formula

Posted by Wilfred on June 15, 2000 6:00 AM

Can any one help.

I need a formula to calculate the week ending date (which is on a Sunday).
So whatever day you want to open the workbook the date will automatically change to this Sundays date.

Can any one help me please?

I was helped out in March with this (for previous Saturday date):


I can't seem to change it to this Sundays date (18/06/00)....Doh!.



Posted by JAF on June 16, 0100 1:09 AM

There may be a way to do this without all these IF statements, but the following does work . . .



Posted by Norman on June 16, 0100 1:57 AM

Great stuff

Great it works.


Posted by mads on June 16, 0100 2:24 AM

Here's a shorter one :-