Consulting | Excel Examples
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.