WEEKNUM Function?

  • Thread starter Thread starter Ken
  • Start date Start date
K

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
 
Ken said:
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
Click to expand...

I think this is just because weeknum is part of the Analysis ToolPak add-in
rather than being an integral part of Excel.
 
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).
 
Back
Top