+ Reply to Thread
Results 1 to 5 of 5

Word - Enter a date and then have other dates update based on the entered date

  1. #1
    Registered User
    Join Date
    12-12-2017
    Location
    Brisbane, Australia
    MS-Off Ver
    2016
    Posts
    27

    Question Word - Enter a date and then have other dates update based on the entered date

    Hi all. I have a question based on Word. Not sure how to do this so hoping someone can help. Will do my best to explain what I need.

    I'm trying to create a form that will ask for a date in one place on the document (actually a cell within a table). It will then take that date and list the 14 individual dates for the fortnight prior in another spot on the form (14 other cells in the same table). Sort of like below. I would enter the Fortnight Ending date and word would then populate the other 14 fields based on that date, all within the one table within Word.

    Fortnight Ending: 28/02/2018 <-- This is the date I would enter

    Dates: | 15/02/2018 | 16/02/2018 | 17/02/2018 | 18/02/2018 | 19/02/2018 | 20/02/2018 | 21/02/2018 | 22/02/2018 | 23/02/2018 | 24/02/2018 | 25/02/2018 | 26/02/2018 | 27/02/2018 | 28/02/2018 | <-- These would be auto calculated

    Is this possible and, if so, how?? Appreciate any help being given

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Word - Enter a date and then have other dates update based on the entered date

    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://windowssecrets.com/forums/sho...ation-Tutorial
    or:
    http://www.gmayor.com/downloads.htm#Third_party
    In particular, look at the item titled Calculate a Date Sequence. Do read the document's introductory material.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Registered User
    Join Date
    12-12-2017
    Location
    Brisbane, Australia
    MS-Off Ver
    2016
    Posts
    27

    Re: Word - Enter a date and then have other dates update based on the entered date

    Thanks macropod. I've had a read and, yes, it shows how to do a date sequence but only from today's date, rather than from whatever date was entered. Maybe I'm missing something so I'll read again, but appears to all be based on today's date which isn't what I require.

  4. #4
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Word - Enter a date and then have other dates update based on the entered date

    If you read the whole topic you'll see it discussed how to use a start date other than today...

  5. #5
    Registered User
    Join Date
    12-12-2017
    Location
    Brisbane, Australia
    MS-Off Ver
    2016
    Posts
    27

    Re: Word - Enter a date and then have other dates update based on the entered date

    Yeah, I found where it talks about changing DATE to your own fieldname for the date you want to use as the base of your calculations, but when I do this, I get "Error! Bookmark not defined", so I'm obviously still missing something. Will keep reading to see if it makes itself at all clearer. Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Enter and Update Data on One Cell based on Date
    By amrit02 in forum Excel General
    Replies: 3
    Last Post: 12-27-2015, 12:21 PM
  2. Replies: 12
    Last Post: 08-05-2015, 05:15 PM
  3. Replies: 2
    Last Post: 10-13-2014, 02:11 PM
  4. Replies: 3
    Last Post: 11-23-2013, 06:21 AM
  5. Popup box asking the effective date, so macro can delete any dates < entered date.
    By shiva_reshs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-07-2013, 07:40 AM
  6. [SOLVED] Calculating a week of dates/days based on the beginning date entered...
    By tiffany04530 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 11-27-2012, 09:55 AM
  7. Replies: 2
    Last Post: 04-14-2005, 12:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1