| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
On Wed, 6 Apr 2005 18:53:09 -0700, "Geocyclist"
wrote: Running Excel 2002 (10.6501.6626) updated to SP3 with Add-Ins Analysis ToolPak enabled. The WEEKNUM formula will only work using weekday 1 and 2 (Week ending Saturday or Sunday). Review of HELP shows this formula should work with days 1 to 7. I need to have my week calculated from Wednesday through Tuesday but the WEEKNUM formula will not work. This is what I have entered; =WEEKNUM(A1,4) where the formated date is in cell A1. The following formula works just fine to sum the week ending Sunday night; =WEEKNUM(A1,2). Any suggestions would be appreciated! I think the HELP file is misleading. I believe the examples given of 1 or 2 are also the limits. So far as suggestions, in your system, what are the weeknumbers for the dates: 31 DEC 2004 1 JAN 2005 ?? --ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Will the Excel WEEKNUM function become ISO 8601 compliant? | Excel Worksheet Functions | |||
| Excel formula similar to a loop in Basic? | Excel Worksheet Functions | |||
| Opening Office Excel file in Works suite | Excel Discussion (Misc queries) | |||
| Recognizing weekends and changing to weekdays in Excel | Excel Discussion (Misc queries) | |||
| Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions | |||
Threaded Mode
