"Weeknum" requires the Analysis ToolPak to be installed & activated*
Chip Pearson's page has details on the "Analysis Toolpak" at:
http://www.cpearson.com/excel/ATP.htm
*Check the "Analysis Toolpak" box via Tools Add-Ins
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
---
"Ev Shafrir" wrote:
-- example: WEEKNUM stopped working;
-- simple numeric calculations work; (calculate switched to 'auto'
-- YEAR function works (with the auto yellow syntax hint)
?? what gives ??
?? is there a function pack to reload or re-enable ??
Using: Excel 2003 (Office 2003)