March 19th, 2010, 07:00 PM
posted to microsoft.public.excel.worksheet.functions
|
|
Monday closest to today's date?
This worked great. Thanks everyone for your help.
"Luke M" wrote in message
...
If today is Monday, do you want today's date or next week?
former:
=TODAY()+CHOOSE(WEEKDAY(TODAY()),1,0,6,5,4,3,2)
latter:
=TODAY()+CHOOSE(WEEKDAY(TODAY()),1,7,6,5,4,3,2)
--
Best Regards,
Luke M
"Ted" wrote in message
...
Hello:
I am seeking a formula that would return the date of the closest Monday
to today's date. The monday would have to be the first one in the
future, not the past. So today, Tuesday March 16, 2010, the formula
would return Monday, March 22, 2010
Thanks in advance
|