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

Document and Annotate! One of the easily overlooked tools provided by Word is the ability to add footnotes and endnotes to your documents. WordTips: Footnotes and Endnotes is the definitive resource guide to using these tools to enhance your documents.

Check out WordTips: Footnotes and Endnotes today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Determining the Week of the Year