| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel Formula WEEKNUM only works on weekdays 1 and 2, why?
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! |
| 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
