Consulting | Excel Examples

User Defined Function for Week Number

Keywords: Format, UserDefined Function, Week, Date

Description: Example of UserDefined function that returns the week number of any date.

Tip: You can use the "ww" value of the Format function to return week number. This value is not available in the user interface. If you include it in a User Defined Function, you can use it to calculate week number in worksheet formulas.

Guide to the Example: Column C in Sheet 1 contains the formula: =WeekNumber(B3)

Download File: Click Here
Tip: Click on the link above and choose "Save" to download the xls workbook to your hard drive or "Open" to open the workbook inside of your browser.

 

Last modified: May 21, 1996