Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jan 2011
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date calculation in Word 2010

    Hi, I've been looking around in this forum for a solution but couldn't find quite the solution I need:
    I need to create a weekly schedule in a Word 2010 document that is used and printed every Mondays, displaying the planning for the week
    Like this:
    Planning for the week starting on: Monday, mmm, dd, yyy
    - Monday dd
    ..
    ..
    - Tuesday dd
    ..
    ..
    - Wednesday dd
    etc

    How do I insert a formula that will calculate automatically 'every mondays' and the following days?
    I assume I cannot start with today's date and add "+7" because if I open the sheet in the middle of the week it will not show a Monday.
    Sorry if I'm unclear... and thanks for your help.

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts
    Hi Humphrey,

    Welcome to the Lounge.

    To see how to do this and just about everything else you might want to do with dates in Word, check out my Microsoft Word Date Calculation Tutorial, at:
    http://lounge.windowssecrets.com/ind...owtopic=249902
    In particular, look at the item titled 'Calculate a Date Sequence'. Do read the document's introductory material.
    Last edited by macropod; 2011-02-05 at 03:36.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. #3
    Lounger
    Join Date
    Oct 2002
    Location
    Mornington Peninsula
    Posts
    42
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Hi there and sorry to butt in, but this topic is of interest and I was going to follow through to your link Paul, but it only returns an error/invalid link message. I'm keen to see your page re the Date sequence in Word. Would you be good enough to just check the link and post again? Many thanks.
    Many thanks for any help, much appreciated.
    Have a great day!
    WebMistress

  4. #4
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts
    Hi webmistress,

    I've just edited the link. It should work now. An alternative download location is:
    http://www.gmayor.com/downloads.htm#Third_party
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  5. #5
    Bronze Lounger
    Join Date
    Apr 2001
    Location
    Peterborough, Ontario, Canada
    Posts
    1,450
    Thanks
    0
    Thanked 1 Time in 1 Post
    You might also putter about Insert - Quick Parts - Field (Date) and Building Blocks in general. (I'm looking through some of that at present myself but can't offer a specific answer to your post.)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •