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.

Date to update after 7 days Please
 

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

Date to update after 7 days Please
 

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.

Date to update after 7 days Please
 

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

Date to update after 7 days Please
 

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