Dates and Times

Tips, Tricks, and Answers

The following articles are available for the 'Dates and Times' topic. Click the article's title (shown in bold) to see the associated article.

Automatically Inserting Tomorrow's Date
Do you routinely need to work with tomorrow's date? Why not create a template that automatically adds tomorrow's date to any point in the document you want. This tip shows how easy this can be.

Changing the Format of Existing Dates
There are a myriad of ways in which a date can be formatted—day first, month first, number of digits in the year, etc. If you want to change the way a date is formatted once it is in your document, how you do so depends on the way in which the date was inserted to begin with.

Determining the Day of the Month
When writing macros, you may need to know which day of the month a particular date represents. Here's how to use the Day function to determine that information.

Determining the Month of the Year
Your macro code may need to determine the month of the year represented by a particular date. You can find the desired information by using the Month function.

Determining the Week of the Year
If you are working with dates in a macro, you may need to determine which week of the year a date falls within. This can be determined with the DatePart function.

Different Ways of Inserting Dates
Word provides a couple of different ways you can insert the current date into a document. Which method should you choose? Understanding the ways that the methods work will help you make the right choice for your needs.

Forcing the Date to the Next Wednesday
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.