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 :)