| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
=WEEKNUM
I am using the WEEKNUM function in a worksheet, but excel seem to use Sunday
as the 1st day of the week. Our working week is Monday to Sunday, Is there anyway of changing it so the Monday is the 1st day of the week? TheRook |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
=WEEKNUM
=WEEKNUM(A1,2)
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "TheRook" wrote in message ... I am using the WEEKNUM function in a worksheet, but excel seem to use Sunday as the 1st day of the week. Our working week is Monday to Sunday, Is there anyway of changing it so the Monday is the 1st day of the week? TheRook |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Weeknum help | Excel Worksheet Functions | |||
| weeknum gone ?? | Excel Worksheet Functions | |||
| Weeknum | Excel Worksheet Functions | |||
| Weeknum | Excel Worksheet Functions | |||
| WEEKNUM() | Excel Discussion (Misc queries) | |||
Linear Mode
