WEEKNUM Function?

[Ken]

Formula containing this function is working fine ...

However, "weeknum" does not capitalize to WEEKNUM like
other functions in the formula or other formulas that I
have ... I thought any formula entered in LowerCase would
change to UpperCase when entered? Up until now I have
always used the LowerCase/UpperCase scenario as a sanity
check for what might be working/not working in my formulas.

"weeknum" is working as "weeknum" instead of "WEEKNUM".

Am I missing something here??? ... Thanks ... Kha

 

[Anon]

Formula containing this function is working fine ...

However, "weeknum" does not capitalize to WEEKNUM like
other functions in the formula or other formulas that I
have ... I thought any formula entered in LowerCase would
change to UpperCase when entered? Up until now I have
always used the LowerCase/UpperCase scenario as a sanity
check for what might be working/not working in my formulas.

"weeknum" is working as "weeknum" instead of "WEEKNUM".

Am I missing something here??? ... Thanks ... Kha

I think this is just because weeknum is part of the Analysis ToolPak add-in
rather than being an integral part of Excel.

 

[Bob Phillips]

Ken,

I think it is because both of these functions are defined in the Analysis
ToolPak and the Analysis ToolPak (VBA) add-ins installed. If you don't have
the Analysis ToolPak installed but do have the Analysis ToolPak (VBA), they
I think it will show the functions in lowercase (detail may not be exact,
but it is something in this area).