Week Number

Returns the week number of a date

Function:

Weeknum(table = string, col = string, new_col = string)

 

Parameters:

Table: Table name on which to perform function

Date Column: Columns to find the Week Number

New Column Name: Name for the column

 

Examples:

Weeknum(table = Budget, col = "Date", new_col = "Week Num+")