OK....how about this?

=TODAY()-CHOOSE(WEEKDAY(TODAY()),5,6,0,1,2,3,4)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Bob" wrote:

Ron,
Thanks for your help. Unfortunately, when TODAY() = 1/7/2007, the date in
cell A1 changes to 1/9/2007. The date in cell A1 should not change until it
is Tuesday (e.g., 1/9/2007, 1/16/2007, etc.). Please refer to my original
question.
Thanks again,
Bob


"Ron Coderre" wrote:

Try this:

=TODAY()-WEEKDAY(TODAY())+3

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Bob" wrote:

I'm trying to create a formula in cell A1 that will always display the date
of the Tuesday of the current week. For example, from 1/2/2007 through
1/8/2007, cell A1 would always display 1/2/2007; from 1/9/2007 through
1/15/2007, cell A1 would always display 1/9/2007, etc.
I have tried using a combination of the WEEKDAY and MOD functions, but I
have been unable to come up with a formula that works. Also, I would prefer
NOT to use a UDF if at all possible.
Any help would be greatly appreciated.
Thanks, Bob