Display Monday of each week

E

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 !
 
R

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 !
Click to expand...


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