=A1-WEEKDAY(A1,2)+1

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Gérard Ducouret" wrote in message
...
Hello,

I have a date from Monday to Friday in the current week. I need to
calculate
the date of the Monday of the previous week in VBA.
How can I do that ?
Thanks a lot

Gérard