How do I calculate work days?

C

ciccia

I have the formula:
=IF(ISERROR(IF('Video Games'!L2>ActivationDate,Week1-'Video
Games'!L2,"")),"",IF('Video Games'!L2>ActivationDate,Week1-'Video
Games'!L2,""))

I tired to do:
=IF(ISERROR(IF('Video Games'!L2>ActivationDate,Week1-'Video
Games'!L2,"")),"",IF('Video Games'!L2>ActivationDate,Workday('Video
Games'!L2,(Week1-'Video Games'!L2)),""))

The valus returs "#Name?"

Appreciate any help:)
 
R

Roger Govier

Do you have the Add in Analysis Toolpack loaded?

If not Tools>Add-Ins> and select Analysis Toolpack
 
C

ciccia

I used "Tools>Add-Ins> and select Analysis Toolpack" and see nothing ( I
never use it before)

Dah! I change Workday to WORKDAY and it works.
However, the number is incoorect such as "38544" present as "23" days:
=IF(ISERROR(IF('Video Games'!L2>ActivationDate,Week1-'Video
Games'!L2,"")),"",IF('Video Games'!L2>ActivationDate,WORKDAY('Video
Games'!L2,Week1-'Video Games'!L2),""))

What is that number? How do I change it to the correct Work days?
 
R

Roger Govier

38544 is the way that Excel stores its dates. It is 11 Jul 2005.
To "correct" it what you neeed it Format>Cells>Date or Custom and choose
the date format you prefer.
The value will remain as 38544 but the presentation will be a date format.
 
Top