The Monday of the previous week with VBA

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

=A1-WEEKDAY(A1,2)+1

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Gérard Ducouret" <gerard.ducouret@wanadooNOSPAM.fr> wrote in message
news:uBm9hZVQGHA.2012@TK2MSFTNGP14.phx.gbl...
> 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
>
>

Date-(weekday(date,2)+6)

--
Regards,
Tom Ogilvy


"Gérard Ducouret" <gerard.ducouret@wanadooNOSPAM.fr> wrote in message
news:uBm9hZVQGHA.2012@TK2MSFTNGP14.phx.gbl...
> 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
>
>

Thanks a lot Tom!
That works !

Gérard

"Tom Ogilvy" <twogilvy@msn.com> a écrit dans le message de
news:OPBFllVQGHA.3272@tk2msftngp13.phx.gbl...
> Date-(weekday(date,2)+6)
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Gérard Ducouret" <gerard.ducouret@wanadooNOSPAM.fr> wrote in message
> news:uBm9hZVQGHA.2012@TK2MSFTNGP14.phx.gbl...
> > 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
> >
> >
>
>