Get start date of weeks

M

Mike

I want to get the following using VBA:

- The current weeks Monday start date e.g. this weeks start date, today =
31/10/2005
- Next weeks start date e.g. 7/11/2005

Thanks.
 
D

Douglas J Steele

DateAdd("d", vbMonday - WeekDay(Date), Date)

Note that this will report that the Monday associated with Sunday, November
6th is November 7th. If that's not okay, post back.
 
Top