Displaying Tuesday's date throughout the week
Ron,
Your solution is very similar to Sandy Mann's except that her solution adds
5 days, whereas your solution subtracts 2 days. Either way, you get the same
result.
Thanks for your help!
Bob
"Ron Rosenfeld" wrote:
On Tue, 2 Jan 2007 08:26:00 -0800, 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
=A5-WEEKDAY(A5-2)+1
Use a date in A5 for testing.
Substitute TODAY() if it does the job for you.
--ron
|