On Tue, 16 Mar 2010 08:50:26 -0500, "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 :)

To always return the NEXT Monday (even if today is a Monday)

=A1+8-WEEKDAY(A1+6)

or, more generally:

=A1+8-WEEKDAY(A1+8-DOW)

DOW: 1=Sun, 2=Mon, etc.

To return the NEXT Monday EXCEPT if today is a Monday:

=A1+7-WEEKDAY(A1+5)

or

=A1+7-WEEKDAY(A1+7-DOW)
--ron