On Mar 16, 9:50*am, "Ted" wrote:
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 :)

How about this?

=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())+7-WEEKDAY(TODAY(),3))