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 |
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 |
All times are GMT +1. The time now is 05:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com