| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
weeknum
have customer whose week starts on saturday and ends friday night, is there a
way to "re-set" weeknum to take this into account or would you have to setup a lookup table? thx |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
weeknum
Doesn't just adding one to the date do what you want?
=WEEKNUM(A1+1) Rick "reno" wrote in message ... have customer whose week starts on saturday and ends friday night, is there a way to "re-set" weeknum to take this into account or would you have to setup a lookup table? thx |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
weeknum
If the date is in A8, try =WEEKNUM(A8+1)
Peter "reno" wrote: have customer whose week starts on saturday and ends friday night, is there a way to "re-set" weeknum to take this into account or would you have to setup a lookup table? thx |
| 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
