Yes, thank you.

Had to get admin to add the "Analysis ToolPak", then it worked. Also, due
to the comments in "Help" added a "-1" to the formula. WEEKNUM counts the
week that includes January 1. Since this year that week was only 2 days, I
don't want it counted as a week.

So the formula as I am using it is "=WEEKNUM(NOW())-1" which today returns
the answer as "9".
Thanks to all for your help.

"David Biddulph" wrote:

Did you look at what Excel help for the WEEKNUM function said, in the
sentence starting "If this function is not available, and returns the #NAME?
error, ..."
?
--
David Biddulph


"kimdnw" wrote in message
...
You are correct that I am looking for the calendar year week count in the
expectation block. I copied this formula and am receiving "#NAME", and
the
internal paranthesis are showing green. Does this mean I need to insert
more
data?

Kim

"GSnyder" wrote:

I'm thinking you can get the expectation by using =Weeknum(now()) as long
as
you're OK with it resetting each year and you start with the calendar
year.

Would that work, or do you need something a little more sophisticated?