Updating Weekly Date Range

[kgeorge]

Is there a way to have a weekly date range that updates automatically?

For example, have the line read "Saturday July 2, 2011 - Friday July 8, 2011" and once July 8th has passed, have it automatically update to "Saturday July 9, 2011 - Friday July 15, 2011"

Thanks in advance!

 

[stwpkcmo]

Not sure exactly if this is what you are looking for, but if the "dates" do not need to be in the same cell the following should work:

In cell A1: =TODAY()-WEEKDAY(TODAY(),1)
In cell B1: =A1+6

That will auto populate the last Saturday in A1 and then B1 gives you the that weeks Friday.

Hopefully that helps a little . . .