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

    Similar Threads Forum Date
    Since When Did We Sikhs Start Getting Depressed, Anxious , OCD And A Host Of Other Mental Illnesses Health & Nutrition Apr 15, 2016
    Malaysia Sikhs Start Free Clinic In Kuala Lumpur Breaking News Mar 10, 2015
    SciTech B-School Startup: Turning Coffee Grounds Into Food Breaking News Sep 2, 2013
    Arts/Society Entrepreneurship Program Gives Trafficked Women a Fresh Start Language, Arts & Culture Sep 2, 2013
    India Sikhs themselves should first start maintaining dignity of turban Breaking News Aug 8, 2013

  3. 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.
    >
    >
     

Share This Page