Loading
Word.Tips.Net WordTips (Menu Interface)

Forcing the Date to the Next Wednesday

Please Note: This article is written for users of the following Microsoft Word versions: 97, 2000, 2002, and 2003. If you are using a later version (Word 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Word, click here: Forcing the Date to the Next Wednesday.

When Alastair prints a document he wants to automatically set the date in that document to the date of the following Wednesday. For example, if today is Thursday the 13th, Alastair would want to display Wednesday the 19th if the document is printed now or on any day up to and including the 19th itself. From next Thursday (20th) Alastair would want the printed date to be the 26th, and so on.

There is no reasonable or convenient way to do this using fields in a document. (I have seem some "pick a future date" field combinations, but they are truly gigantic and not for casual use.) A better solution is to use a macro to insert, at the insertion point, the date of whatever the next Wednesday happens to be. The following is an example that shows how simple such a macro can be:

Sub ForceWednesday()
    Dim dMyDate As Date
    dMyDate = Date
    While WeekDay(dMyDate) <> 4
        dMyDate = dMyDate + 1
    Wend
    Selection.TypeText Text:=Format(dMyDate, "mmmm d, yyyy")
End Sub

When you run the macro, it assigns the current date to the dMyDate variable. This variable is continually incremented until the weekday is 4 (a Wednesday). The date is then formatted and typed at the location of the insertion point.

The macro could be easily modified to always put the next Wednesday date in a specific place of the document. All you need to do is modify it so that it searches for, say, a bookmark and replaces the bookmark with the formatted date. You could even set up Word so that the macro is run during the BeforePrint event, which means it will be executed just before printing.

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (3849) applies to Microsoft Word 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Word (Word 2007 and later) here: Forcing the Date to the Next Wednesday.

Related Tips:

Do More in Less Time! Are you ready to harness the full power of Word 2013 to create professional documents? In this comprehensive guide you'll learn the skills and techniques for efficiently building the documents you need for your professional and your personal life. Check out Word 2013 In Depth today!

 

Leave your own comment:

*Name:
Email:
  Notify me about new comments ONLY FOR THIS TIP
Notify me about new comments ANYWHERE ON THIS SITE
Hide my email address
*Text:
*What is 5+3 (To prevent automated submissions and spam.)
 
 
           Commenting Terms

Comments for this tip:

Augustine    02 Apr 2016, 05:31
Dear Sir, since I did not get any response from you, I made the following code to Forcing the Date to the next Sunday:
Sub AutoNew()
    Dim dMyDate As Date
    dMyDate = Date
    While Weekday(dMyDate) <> 1
        dMyDate = dMyDate + 1
    Wend
    With ActiveDocument.Bookmarks("MyDate").Range
' Selection.TypeText Text:=Format(dMyDate, "dd.mm.yyyy")
    .InsertBefore Format(dMyDate, "dd.mm.yyyy")
    End With
End Sub
Augustine    05 Feb 2016, 12:34
Dear Mr.Wyatt, I found this macro useful for me. However, the macro does not execute by itself. I have to manually run it. Is there a way to automatically execute it. Besides, when I bookmark, say e.g. "MyDate", what lines do I need to insert in the macro, so that the macro replaces the bookmark?
Thanks & Regards
Augustine
 
 

Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us

 

Advertise with Us

Our Privacy Policy

Our Sites

Tips.Net

Beauty and Style

Cars

Cleaning

Cooking

DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2016)

Gardening

Health

Home Improvement

Money and Finances

Organizing

Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2016)

Our Products

Helpful E-books

Newsletter Archives

 

Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2016 Sharon Parq Associates, Inc.