Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Get Start Date Of Weeks

Discussion in 'Information Technology' started by Mike, Nov 1, 2005.

Tags:
  1. Mike

    Mike
    Expand Collapse
    Guest

    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.
     
  2. Loading...


  3. OP
    Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    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.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Mike" <mike@hello.com> wrote in message
    news:OxZKBSh3FHA.3244@tk2msftngp13.phx.gbl...
    > 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.
    >
    >
     
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     


Share This Page