Determining the Week of the Year

Summary: 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. (This tip works with Microsoft Word 97, Word 2000, Word 2002, Word 2003, and Word 2007.)

You may have a need to find out the current week of the year. For instance, your company may require to you utilize the week number for accounting or tracking purposes. VBA provides a handy function that allows you to quickly and easily determine the current week of the year:

iThisWeek = DatePart("ww", Date)

When executed, iThisWeek will be equal to the current week number. Notice that this example uses the Date function. If you want to determine the week number for a different date, simply substitute that date in place of the Date function.

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

Create and Merge! Using Word's mail merge tool you can quickly and easily combine data from a variety of data sources to create great individualized documents that incorporate your data in ways that you control. WordTips: Mail Merge Magic is an invaluable source for learning how to harness the full power of Word's mail merging capabilities.

Check out WordTips: Mail Merge Magic today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Determining the Week of the Year