weeknum function

K

Kelvin

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
 
P

Pete_UK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top