Display Monday of each week

[Eileen]

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 !

 

[T. Valko]

Try this:

=A1-WEEKDAY(A1,2)+1

 

[Ron Rosenfeld]

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