Posted to microsoft.public.excel.worksheet.functions

Cam

external usenet poster

Posts: 165

WEEKNUM function not working

Hello,

I have a cell to calculate current week number, =WEEKNUM(TODAY())
and I have the analysis toolpak checked in the Add-In menu, but it still
result "####". I am running Excel 2003.

What other alternative can I use to show current week? Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Weeknum function help	Cam	Excel Worksheet Functions	1	April 2nd 10 03:29 PM
Weeknum function	Brad	Excel Discussion (Misc queries)	0	June 30th 08 04:47 PM
WEEKNUM Function	Trevor Aiston	Excel Worksheet Functions	3	November 27th 06 12:03 PM
Weeknum Function	AnitaML	Excel Worksheet Functions	3	August 25th 05 04:25 PM
WeekNUM Function	Need2FX	Excel Worksheet Functions	1	April 14th 05 04:21 AM

All times are GMT +1. The time now is 11:26 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us