Always making the date the previous sunday.

**Rgaherty** · 12-14-2007, 09:19 AM

Is there a way to make the date in a cell check the current date then fall back to the previous sunday unless today actually happens to be sunday? So for example it would look at today and make the date 12/9/2007 rather than 12/14/2007

**mudraker** · 12-14-2007, 09:43 AM

=today()-weekday(today())+1

**Rgaherty** · 12-14-2007, 10:01 AM

That works perfectly, thank you very much.

**Superhatch** · 12-17-2007, 11:16 AM

How would I correct the formula so that the cell would always present the date as the next Sunday unless it is Sunday? I'm trying on my own but I'm a bit of a newbie...

**Superhatch** · 12-17-2007, 11:46 AM

=TODAY()+WEEKDAY(TODAY())+4 works for this week, but I'm not sure why, or if it will work for next week, any correction or explanation would be greatly appreciated.

**oldchippy** · 12-17-2007, 11:56 AM

Try this,

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

**Superhatch** · 12-17-2007, 12:05 PM

I did a litte research, and found how weekday, and dates work. So that formula makes sense to me now

Thanks much for the help!!

**Superhatch** · 12-17-2007, 12:17 PM

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

Just for clarification...if I calculate out this coming Sunday..the formula would be 23rd+7=30-1+1...that would equal the 30th. I've read about how excel serializes Sunday-Saturday as 1-7, but if you add the today # on a Sunday you get the 30th which would be the following Sunday. Does (TODAY()) compensate for that somehow?