Date to update after 7 days Please

S

Steved

Hello from Steved

In Cell B3 I would like to put a formula that updates every Sunday to that
date off that day.

How would one go about this please.

Thankyou.
 
E

Elkar

If I understand you correctly, you basically want a formula that will show
the date of the most recent Sunday? If so, this should work for you:

=TODAY()-WEEKDAY(TODAY())+1

HTH,
Elkar
 
Top