WEEKNUM function returns #name in Excel 2003

I have Excel 2003 installed.

When I enter a WEEKNUM function into a cell I get #name returned. When I do
a check on the formula Excel help tells me there is an unrecognized entry.

Basically my formula looks like this

in cell C5 I have =weeknum(A5,1)
in cell A5 I have the date 12/08/2003

I'v done fourmulas for the date in A5 to break out the year, month, and day,
then re-assembled them with 'date' forumla to make sure it's a valid date
and to get a date serial number, but however I have the dates entered, the
weeknum formula doesn't work. It's as if the function is an invalid
function to begin with, but I found the formula in Excel's help files.

Has anyone else experienced this problem? And does anyone have a solution?




----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---

J
Thu Dec 25 17:42:05 CST 2003

Load the Analysis Toolpak Addin (Tools/Addins.../check the
appropriate checkbox).

In article <3feb5d8c$1_2@127.0.0.1>,
"Alan K. Martinez" <akmartinez1@newsfeeds.com> wrote:

> I have Excel 2003 installed.
>
> When I enter a WEEKNUM function into a cell I get #name returned. When I do
> a check on the formula Excel help tells me there is an unrecognized entry.
>
> Basically my formula looks like this
>
> in cell C5 I have =weeknum(A5,1)
> in cell A5 I have the date 12/08/2003
>
> I'v done fourmulas for the date in A5 to break out the year, month, and day,
> then re-assembled them with 'date' forumla to make sure it's a valid date
> and to get a date serial number, but however I have the dates entered, the
> weeknum formula doesn't work. It's as if the function is an invalid
> function to begin with, but I found the formula in Excel's help files.
>
> Has anyone else experienced this problem? And does anyone have a solution?
>
>
>
>
> ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet
> News==----
> http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000
> Newsgroups
> ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption
> =---

Alan
Fri Dec 26 08:19:05 CST 2003

Thank you... that solved the problem...


"J.E. McGimpsey" <jemcgimpsey@mvps.org> wrote in message
news:jemcgimpsey-7A54D0.16420525122003@msnews.microsoft.com...
> Load the Analysis Toolpak Addin (Tools/Addins.../check the
> appropriate checkbox).
>
> In article <3feb5d8c$1_2@127.0.0.1>,
> "Alan K. Martinez" <akmartinez1@newsfeeds.com> wrote:
>
> > I have Excel 2003 installed.
> >
> > When I enter a WEEKNUM function into a cell I get #name returned. When
I do
> > a check on the formula Excel help tells me there is an unrecognized
entry.
> >
> > Basically my formula looks like this
> >
> > in cell C5 I have =weeknum(A5,1)
> > in cell A5 I have the date 12/08/2003
> >
> > I'v done fourmulas for the date in A5 to break out the year, month, and
day,
> > then re-assembled them with 'date' forumla to make sure it's a valid
date
> > and to get a date serial number, but however I have the dates entered,
the
> > weeknum formula doesn't work. It's as if the function is an invalid
> > function to begin with, but I found the formula in Excel's help files.
> >
> > Has anyone else experienced this problem? And does anyone have a
solution?
> >
> >
> >
> >
> > ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet
> > News==----
> > http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000
> > Newsgroups
> > ---= 19 East/West-Coast Specialized Servers - Total Privacy via
Encryption
> > =---




----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---

anonymous
Sun Jan 25 02:46:07 CST 2004

You could enter weeknum in your excel help file and then you'll find what you want.

Kevin Hu