VBA Date of Previous Weeks Monday From Current Date

Hi, I wonder whether someone may be able to help me please.

I'm trying to calculate the date of the previous weeks Monday from the curernt date and from the searching I've done I've put together the following: `.Cells(1, 3).Offset.Value = Evaluate(Date - (Weekday(Date, 2) + 6))`

The problem I have when I run this, is that the cells returns the value of `00 Jan 00` when I would expect the 17th November 2014, so clearly I've made a mistake somewhere but I'm not sure where.

I just wondered whether someone may be able to look at this please and offer some guidance on where I may have gone wrong.

Many thanks and kind regards

Chris

Try this...

Please Login or Register  to view this content.

Hi,

The Evaluate() function take a string as the argument, so your code should be like this :

Please Login or Register  to view this content.

Regards

The line you posted has a syntax error, Offset needs an argument.
You might use these UDFs.

Please Login or Register  to view this content.