Get start date of weeks

  • Thread starter Thread starter Mike
  • Start date Start date
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Get date for start of week 3
Run a query based on a start date and end date. The date are the . 4
Excel Excel VBA Script help 0
subform infor on main form! 1
Help to Highlight Excel Row based on Weekly Date Range 2
Conditional Expression 10
Count By week 1
how to get the next monday? 4

Back
Top