Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
weeknum function
Does anyone know why I would get an error of " #name? " when using the
weeknum function. =weeknum(a3,1) was used on a date field to attempt to get the week number associated with the particular date located at A3. Any ideas? Thanks -- KWB |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
weeknum function
If you checked in Excel Help you would find the answer quite easily - if it
is not available (i.e. returning #NAME?) then you need to install the Analysis Tool Pak. Hope this helps. Pete "Kelvin" wrote in message ... Does anyone know why I would get an error of " #name? " when using the weeknum function. =weeknum(a3,1) was used on a date field to attempt to get the week number associated with the particular date located at A3. Any ideas? Thanks -- KWB |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=WEEKNUM function | Excel Worksheet Functions | |||
WEEKNUM Function | Excel Worksheet Functions | |||
Weeknum Function | Excel Worksheet Functions | |||
WeekNUM Function | Excel Worksheet Functions | |||
weeknum function | Excel Worksheet Functions |