weeknum function

[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

 

[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