Determining the Day of the Year

Summary: Need to find out the day of the year for a particular date? It's easy to do if you are using a macro. All you need to do is use the DatePart function. (This tip works with Microsoft Word 97, Word 2000, Word 2002, Word 2003, and Word 2007.)

If you are writing macros in VBA, you may have a need to determine the current day of the year. For instance, you might want to know that February 21 is the 52 day of the year. VBA includes a handy function that allows you to quickly and easily determine the current day of the year:

iThisDay = DatePart("y", Date)

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

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

Save Time! WordTips has been published weekly since early 1997. Past issues are available in convenient WordTips archives. Have your own enhanced archive of WordTips at your fingertips, available to use at any time!

Check out WordTips Archives today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Determining the Day of the Year