Please Note: This article is written for users of the following Microsoft Word versions: 2007 and 2010. If you are using an earlier version (Word 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Word, click here: Determining the Day of the Year.
by Allen Wyatt
(last updated December 10, 2015)
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.
WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (12436) applies to Microsoft Word 2007 and 2010. You can find a version of this tip for the older menu interface of Word here: Determining the Day of the Year.
Learning Made Easy! Quickly teach yourself how to format, publish, and share your content using Word 2013. With Step by Step, you set the pace, building and practicing the skills you need, just when you need them! Check out Microsoft Word 2013 Step by Step today!
You can make running macros very easy if you assign a shortcut key to the macro. This tip demonstrates how easy it is to ...Discover More
If you are applying formatting from within a macro, you may want to change the alignment of various paragraphs. Here's how ...Discover More
When writing macros, you may need to know which day of the month a particular date represents. Here's how to use the Day ...Discover More
FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu interface.