Get the last weeknum with DateSerial in Excel VBA

Hello Guys,

How can I get the last weeknum using the below example:

Please Login or Register  to view this content.

With the above example, I am getting the weeknum 14(which is the current week), but I need to get the weeknum 13 (from date March 22 to 28, 2015).


Thanks!!

Add a -1

Please Login or Register  to view this content.

Thanks a lot John!!

You're welcome. Glad to help out and thanks for the feedback.