| 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:) |
| 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) | |||
Threaded Mode
