NETWORKDAYS - Business Days
Fred G. wrote on June 08, 2005 18:06 EST |
The real power of this function comes when one uses the optional third parameter. This parameter allows you to create a custom list of holidays, which are used in making the calculation. This makes it an international function, going far beyond ignoring weekends done in the basic function.
Surprised the "tip" author ignored this. |
Reply: Fred G
Alan wrote on June 08, 2005 22:27 EST |
Hi Fred,
[QUOTE=Fred G.]The real power of this function comes when one uses the optional third parameter. This parameter allows you to create a custom list of holidays, which are used in making the calculation. This makes it an international function, going far beyond ignoring weekends done in the basic function.
Surprised the "tip" author ignored this.[/QUOTE]I agree totally.
I would also add though that this function is not one I suggest using too often since it is, essentially, a UDF and requires that the add-in is installed.
Most (?) users don't have it installed and don't even know what an add-in is. They will just think that your spreadsheet doesn't work!
There is no *need* to use this function - it can be created from real core excel functions, but takes more work and is harder to 'read' afterwards.
There are always exceptions!
Alan. |
Not working
Hans A wrote on June 28, 2005 07:27 EST |
Hi, tried this but the result is:
date in date vic Days
04/06/2005 09/06/2005 #VALUE!
Can anybody tell me what I should do ? |
Reply: Hans A
Alan wrote on June 29, 2005 02:41 EST |
Hi Hans A,
[QUOTE=Hans A]Hi, tried this but the result is:
date in date vic Days
04/06/2005 09/06/2005 #VALUE!
Can anybody tell me what I should do ?[/QUOTE]If you enter this:
=NETWORKDAYS("4 Jun 2005","9 Jun 2005")
You should get a result of 4 (assuming you have the add-in installed).
HTH,
Alan. |
Which Add-In?
mmcnown wrote on January 11, 2006 11:16 EST |
[QUOTE=Alan]Hi Hans A,
If you enter this:
=NETWORKDAYS("4 Jun 2005","9 Jun 2005")
You should get a result of 4 (assuming you have the add-in installed).
HTH,
Alan.[/QUOTE]
Which Add-In is required for this function to work? |
Add-in?
mmcnown wrote on December 31, 1969 19:00 EST |
| What add-in is required for this to work properly? |
re: addin...
Tachyon wrote on December 31, 1969 19:00 EST |
This function IS included in version 2.x versions and doesn't require any addins.
It's a simple, and useful function, especially for things like estimating pay, or total payroll projections etc.
|
davesexcel wrote on November 04, 2006 08:11 EST |
Analysis toolpac
go to tools add-ins and select it |