I have been using week number function from quite some time now, but I came across a situation where I need to change week start from Sunday to Thursday.
Syntax for WEEKNUM
WEEKNUM(serial_number,[return_type])
Till now I had never used return type argument as it was optional but this does the trick. By default if not provided its 1 i.e. Sunday. But it has other options as well
| Return_Type | Start Day of Week |
| 1 | Sunday |
| 2 | Monday |
| 11 | Monday |
| 12 | Tuesday |
| 13 | Wednesday |
| 14 | Thursday |
| 15 | Friday |
| 16 | Saturday |
I used
How to use Date Function in Excel 2010
=WEEKNUM(A1,14) and got my result.
