Date to update after 7 days Please

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.

Use this formula

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

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


"Steved" wrote:

> 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.

Exactly what I required and I thank you both.

Cheers.

"daddylonglegs" wrote:

>
> Use this formula
>
> =TODAY()-WEEKDAY(TODAY())+1
>
>
> --
> daddylonglegs
> ------------------------------------------------------------------------
> daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
> View this thread: http://www.excelforum.com/showthread...hreadid=511997
>
>

Thankyou

"daddylonglegs" wrote:

>
> Use this formula
>
> =TODAY()-WEEKDAY(TODAY())+1
>
>
> --
> daddylonglegs
> ------------------------------------------------------------------------
> daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
> View this thread: http://www.excelforum.com/showthread...hreadid=511997
>
>