| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How do I calculate work days?
I have the formula:
=IF(ISERROR(IF('Video Games'!L2ActivationDate,Week1-'Video Games'!L2,"")),"",IF('Video Games'!L2ActivationDate,Week1-'Video Games'!L2,"")) I tired to do: =IF(ISERROR(IF('Video Games'!L2ActivationDate,Week1-'Video Games'!L2,"")),"",IF('Video Games'!L2ActivationDate,Workday('Video Games'!L2,(Week1-'Video Games'!L2)),"")) The valus returs "#Name?" Appreciate any help:) |
|
#2
|
|||
|
|||
|
Do you have the Add in Analysis Toolpack loaded?
If not ToolsAdd-Ins and select Analysis Toolpack -- Regards Roger Govier "ciccia" wrote in message ... I have the formula: =IF(ISERROR(IF('Video Games'!L2ActivationDate,Week1-'Video Games'!L2,"")),"",IF('Video Games'!L2ActivationDate,Week1-'Video Games'!L2,"")) I tired to do: =IF(ISERROR(IF('Video Games'!L2ActivationDate,Week1-'Video Games'!L2,"")),"",IF('Video Games'!L2ActivationDate,Workday('Video Games'!L2,(Week1-'Video Games'!L2)),"")) The valus returs "#Name?" Appreciate any help:) |
|
#3
|
|||
|
|||
|
I used "ToolsAdd-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'!L2ActivationDate,Week1-'Video Games'!L2,"")),"",IF('Video Games'!L2ActivationDate,WORKDAY('Video Games'!L2,Week1-'Video Games'!L2),"")) What is that number? How do I change it to the correct Work days? "Roger Govier" wrote: Do you have the Add in Analysis Toolpack loaded? If not ToolsAdd-Ins and select Analysis Toolpack -- Regards Roger Govier "ciccia" wrote in message ... I have the formula: =IF(ISERROR(IF('Video Games'!L2ActivationDate,Week1-'Video Games'!L2,"")),"",IF('Video Games'!L2ActivationDate,Week1-'Video Games'!L2,"")) I tired to do: =IF(ISERROR(IF('Video Games'!L2ActivationDate,Week1-'Video Games'!L2,"")),"",IF('Video Games'!L2ActivationDate,Workday('Video Games'!L2,(Week1-'Video Games'!L2)),"")) The valus returs "#Name?" Appreciate any help:) |
|
#4
|
|||
|
|||
|
38544 is the way that Excel stores its dates. It is 11 Jul 2005.
To "correct" it what you neeed it FormatCellsDate or Custom and choose the date format you prefer. The value will remain as 38544 but the presentation will be a date format. -- Regards Roger Govier "ciccia" wrote in message ... I used "ToolsAdd-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'!L2ActivationDate,Week1-'Video Games'!L2,"")),"",IF('Video Games'!L2ActivationDate,WORKDAY('Video Games'!L2,Week1-'Video Games'!L2),"")) What is that number? How do I change it to the correct Work days? "Roger Govier" wrote: Do you have the Add in Analysis Toolpack loaded? If not ToolsAdd-Ins and select Analysis Toolpack -- Regards Roger Govier "ciccia" wrote in message ... I have the formula: =IF(ISERROR(IF('Video Games'!L2ActivationDate,Week1-'Video Games'!L2,"")),"",IF('Video Games'!L2ActivationDate,Week1-'Video Games'!L2,"")) I tired to do: =IF(ISERROR(IF('Video Games'!L2ActivationDate,Week1-'Video Games'!L2,"")),"",IF('Video Games'!L2ActivationDate,Workday('Video Games'!L2,(Week1-'Video Games'!L2)),"")) The valus returs "#Name?" Appreciate any help:) |
|
#5
|
|||
|
|||
|
Thanks, Roger,
I finally use NETWOKRDAY. Appreciate "Roger Govier" wrote: 38544 is the way that Excel stores its dates. It is 11 Jul 2005. To "correct" it what you neeed it FormatCellsDate or Custom and choose the date format you prefer. The value will remain as 38544 but the presentation will be a date format. -- Regards Roger Govier "ciccia" wrote in message ... I used "ToolsAdd-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'!L2ActivationDate,Week1-'Video Games'!L2,"")),"",IF('Video Games'!L2ActivationDate,WORKDAY('Video Games'!L2,Week1-'Video Games'!L2),"")) What is that number? How do I change it to the correct Work days? "Roger Govier" wrote: Do you have the Add in Analysis Toolpack loaded? If not ToolsAdd-Ins and select Analysis Toolpack -- Regards Roger Govier "ciccia" wrote in message ... I have the formula: =IF(ISERROR(IF('Video Games'!L2ActivationDate,Week1-'Video Games'!L2,"")),"",IF('Video Games'!L2ActivationDate,Week1-'Video Games'!L2,"")) I tired to do: =IF(ISERROR(IF('Video Games'!L2ActivationDate,Week1-'Video Games'!L2,"")),"",IF('Video Games'!L2ActivationDate,Workday('Video Games'!L2,(Week1-'Video Games'!L2)),"")) The valus returs "#Name?" Appreciate any help:) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DOnt calculate leap year | Excel Worksheet Functions | |||
| Calculate running target by days in the month | Excel Worksheet Functions | |||
| how do we calculate T-bill Price in 365 days year. | Excel Worksheet Functions | |||
| Calculate work hours between two dates | Excel Worksheet Functions | |||
| How do I use the IF function to calculate date | Excel Discussion (Misc queries) | |||
Hybrid Mode
