WEEKNUM FUNCTION

[Peter Doyle]

I have a column of dates in a table which is manually
entered. I am trying to set up another column which then
works out the Week Number for the entered date
automatically.

My problem is that I cannot get the weeknum function to
work when I refenence the cell in the other column. All
that happens is that I get a #value! error.

If the cell I want to reference is E2 I am entering
=weeknum("(e2)",2)

Can anyone help?

Cheers
Peter

 

[Anders S]

Just a tip,

I use the Insert Function dialog box as much as possible. Saves me a lot of
typing and syntax errors.

Regards,
Anders

 

[peter]

Cheers that works a lot better

-----Original Message-----
=WEEKNUM(E2,2)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

--------------------------------------------------------- -------------------
Attitude - A little thing that makes a BIG difference
--------------------------------------------------------- -------------------






.