Determining the Week of the Year

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.