Date to update after 7 days Please

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparison of columns using Conditional Formatting 3
Does date in Cell A1 occur between the date in M1 and Date in X1 1
Formula to tell day of week 2
I forgot how to duplicate SCH 051 2
Future date with six day week including holidays 1
IF and Date 6
Trailing 30 days sum calculation with excel 1
Find a Day in a Calendar 3

Back
Top