Word.Tips.Net Welcome toWord.Tips.Net

Helpful Links

Tips.Net Home
WordTips Home

Ask a Word Question
Make a Comment

Tips.Net Store

WordTips FAQ
WordTips Premium

Learn Access Now
Free Printable Forms

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips

Advertise on the
WordTips Site

Newest Tips

Arranging Document Windows

Specifying a Backup Location

Controlling Chart Gridlines

Merging Table Cells

Collapsing and Expanding Subdocuments

Zooming With the Keyboard

Initiating a New Search

 

Forcing the Date to the Next Wednesday

Summary: Working with today's date in Word is easy. Trying to manipulate dates to come up with a future one can be an entirely different story. This tip provides a quick and easy macro that inserts the date of whatever next Wednesday happens to be. (This tip works with Microsoft Word 97, Word 2000, Word 2002, Word 2003, and Word 2007.)

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.

Tip #3849 applies to Microsoft Word versions: 97 | 2000 | 2002 | 2003 | 2007

Find and Replace Almost Anything! An invaluable resource for learning how to harness the full power of Word's search and replace capabilities. You'll discover everything you need in order to master all the intricacies of finding and replacing elements of your document, including the super-powerful "wildcard searches" available in Word.
 
Check out WordTips: Find and Replace today!