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.
Adding Automatic Time Stamps
Your computer knows the current date and time, and Word provides ways you can get that date and time into your document. Doing so easily and in the format you want may be a challenge, but it is not an insurmountable one.
Automatically Determining a Due Date
When you are doing a mail merge in Word, you may need to calculate a date sometime in the future. Word doesn't include an option to do this, but there are a couple of workarounds you can try.
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.