On Wed, 17 Oct 2007 03:22:03 -0700, ellebelle
wrote:

If would like a function that rounds a date to the nearest Monday. Is there
such a function?

Ellen

=A1-WEEKDAY(A1)+2+7*(WEEKDAY(A1)5)

If I understand you correctly, up through Thursday, the nearest Monday is the
Monday before; after Thursday, the nearest Monday is the Monday following.

If you want the split to be on a different day, then just change the 5 to
something else.
--ron