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 Rock-Solid Lists! Bulleted and numbered lists can help make your writing clearer and easier to follow. If not done properly, however, they can be a nightmare to work with. Discover the ins and outs of Word's lists with this great reference available in two versions.

Check out Word Bullets and Numbering today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Determining the Week of the Year