What I want to do is derive the date of the previous Monday from a date textbox.
the code I have at the moment is
However this returned 15/05/2011 (which was Sunday), where am I going wrong?
the code I have at the moment is
Code:
ActiveCell.Offset(0, 69) = CDate(txtDate.Value) - Weekday(CDate(txtDate.Value), vbMonday)
However this returned 15/05/2011 (which was Sunday), where am I going wrong?