Thread: The Monday of the previous week with VBA
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default The Monday of the previous week with VBA
Date-(weekday(date,2)+6)

--
Regards,
Tom Ogilvy


"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




Reply With QuoteReply With Quote