Thread
:
Displaying Tuesday's date throughout the week
View Single Post
#
8
Posted to microsoft.public.excel.worksheet.functions
Bob
external usenet poster
Posts: 972
Displaying Tuesday's date throughout the week
Sandy,
Interesting solution. It took me a few minutes to understand how the logic
works, but now that I understand it, it is very slick!
Thanks a lot!
Bob
"Sandy Mann" wrote:
Bob,
Does:
=TODAY()-WEEKDAY(TODAY()+5,1)+1
Do what you want?
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
with @tiscali.co.uk
"Bob" wrote in message
...
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
Reply With Quote
Bob
View Public Profile
Find all posts by Bob