weeknum function

  • Thread starter Thread starter Kelvin
  • Start date Start date
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
 
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
 
Back
Top