Excel Formula in XP and NT
 

Hi all,

I have an excel macro running in NT4.0 + Office97 and I have use some
formula such as EMONTH...

After upgrade to XP + Office97, I find the formula is less than in NT, eg.
Emonth cannot be find in the "Date and Time" formula.

Is it because of compatiable of the XP and Office97? Will Office2000 or
OfficeXP resolve this?

Thanks,
Jack

Excel Formula in XP and NT
 

Hi Jack

EOMONTH is one of the analysis tool-pak add-in formulas
go to tools / add-ins - check analysis tool-pak to enable.

Cheers
JulieD

"msenquiry" wrote in message
...
Hi all,

I have an excel macro running in NT4.0 + Office97 and I have use some
formula such as EMONTH...

After upgrade to XP + Office97, I find the formula is less than in NT, eg.
Emonth cannot be find in the "Date and Time" formula.

Is it because of compatiable of the XP and Office97? Will Office2000 or
OfficeXP resolve this?

Thanks,
Jack