Wow! My recollection on how to do that was way off! ;-)

Thanks for the help. I've added your formula to my file and it works
perfectly.

--Tom

"Ron Rosenfeld" wrote in message
...
On Wed, 6 May 2009 21:50:41 -0600, Thomas M.
wrote:

I found a formula on the Internet that works.

=TODAY()-WEEKDAY(TODAY())+IF(WEEKDAY(TODAY())6,13,6)

Anyone have a better way of doing this?

--Tom

As Rick wrote, merely substitute TODAY() for A1 in the formula I
previously
posted.

=A1+7-WEEKDAY(A1+1)

or put TODAY() in A1 or some other cell to be referenced.

The formula I posted can be generalized to:

=A1+7-WEEKDAY(A1+7-DOW)

where DOW is Day Of Week and 1=Sun,2=Mon...6=Fri,7=Sun

--ron