=A1-WEEKDAY(A1)+2

Tyro

"Charles" wrote in message
...
I am looking for a date function that will return the Monday for the week
in
which the given date is in. For example cell A1 has the date 2-13-2008 (a
Wednesday) I would like to have a function that would return 2-11-2008
(Monday). Any ideas?
Thanks in advance!!