| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
WEEKNUM calculations for week stating with Tuesday
You are right, but in this case Excel is behind the developments in the
world. Does Excel2007 have this feature? Regards, Stefi Rick Rothstein (MVP - VB) ezt *rta: I'm guessing you haven't heard of the "4-day work week" that many companies have already adopted? One of the methods of implementing this schedule is to give the workers Monday off in conjunction with the normal weekend. Rick "Stefi" wrote in message ... There is no known place in the world where week starts with Tuesday-Friday, therefore Excel doesn't have this feature. What do you want to do? Regards, Stefi P C Verma ezt *rta: While calculating WEEKNUM stating from Tuesday to Friday i am getting error massage #NUM# but for week staring from Sunday and Monday it calculating correctly. What could be the reason and how to work around it correctly. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing & Stating The Nearest Matching | Excel Discussion (Misc queries) | |||
| Rolling 12 week calculations | Excel Worksheet Functions | |||
| start/end dates of a week given just the weeknum() value | Excel Discussion (Misc queries) | |||
| reverse week count calculations | Excel Worksheet Functions | |||
| weeknum function says jan1=week1, mod to first 4 day week needed | Excel Discussion (Misc queries) | |||
Threaded Mode
