im using the WEEKNUM function in my excel but when other users in my office
open my files it doesn't work?

All the other date functions work.

any ideas?

Hi Ciara

from help
"If this function is not available, and returns the #NAME? error, install
and load the Analysis ToolPak add-in."

you must have the Analysis ToolPak add-in enabled on your machines, the
others in the office will need to do the same (tools / add-in, tick analysis
toolpak)

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Ciara" wrote in message
...
im using the WEEKNUM function in my excel but when other users in my
office
open my files it doesn't work?

All the other date functions work.

any ideas?