This function returns the week of the given date as a number.
WeekNum([Date],[Return Type])
Date is the date to return the week number from
Return Type is a number representing the day on which the week starts
Return Type | Number returned |
|---|---|
| 1 or Omitted | Sunday |
| 2 | Monday |
| 11 | Monday |
| 12 | Tuesday |
| 13 | Wednesday |
| 14 | Thursday |
| 15 | Friday |
| 16 | Saturday |
| 17 | Sunday |
| 21 | Monday |
Rule | Meaning |
|---|---|
| WeekNum(Today()) | If this function is called on 10/18/2010 it will return 43 as the week number |
| WeekNum("10/18/2010",12) | This will return 42 as the date given falls on a Monday and the week is set to start on a Tuesday (12). |