Setting up a date that changes once a week

[cheesesteak]

I would like to set up a cell that will be labeled "Week Beginning" and have that date change automatically at the beginning of every week, either on Sunday or Monday . . . most likely Sunday. I can't seem to figure out how to do this.

I'm just starting out with Excel 2007 and perhaps the newbie forum would be more appropriate but, I thought I'd give this board a try first.

Thanks for listening!!!

[rylo]

Hi

How about

="Week Beginning: " & TEXT(NOW()-WEEKDAY(NOW())+1,"dd/mm/yyyy")

rylo

[mikerickson]

You may have to add a constant to make this come to the right day of the week, but this incriments by 7 once a week.

=TODAY()-WEEKDAY(TODAY())

[cheesesteak]

You may have to add a constant to make this come to the right day of the week, but this incriments by 7 once a week.

=TODAY()-WEEKDAY(TODAY())

Thanks . . .

To start the week at today, Sunday and ending with Saturday the 24th I used

=TODAY()+WEEKDAY(0,2) . . .

Will this function increment once a week or once a day?

cheese . . .

[cheesesteak]

Thanks . . .

To start the week at today, Sunday and ending with Saturday the 24th I used

=TODAY()+WEEKDAY(0,2) . . .

Will this function increment once a week or once a day?

cheese . . .

Nope . . . this didn't work

=TODAY()+WEEKDAY(,2)+1 gives me the right week ending date for this week for now . . . but I'm not sure what I did or what it means or if it'll give me the correct values when next week comes around.

[mikerickson]

I think the formula that you'ld want is

=TODAY()-WEEKDAY(TODAY(),2)

[daddylonglegs]

If you want the formula to change to 25th May 2008 on this coming Sunday and remain on that date until the next Sunday.....

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

[cheesesteak]

If you want the formula to change to 25th May 2008 on this coming Sunday and remain on that date until the next Sunday.....

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

Thank you . . . that'll work just fine!

cheese . . .