On Wed, 25 Jun 2008 23:05:00 -0700, Eileen <Eileen @discussions.microsoft.com
wrote:

I have a column with dates, and I need to return the Monday of that week. For
example, I need a simple forumular to return 6/23 (Monday) when I enter 6/25
(Thursday).

Can someone help please ?

Thanks !


=A1+1-WEEKDAY(A1-1)
--ron