Try this:

=A1-WEEKDAY(A1,2)+1

--
Biff
Microsoft Excel MVP


"Eileen" <Eileen @discussions.microsoft.com wrote in message
...
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 !