| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation between 2 date?
Hello,
What formula or how do I calculate number of days between 2 date excluding weekend and holiday? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculation between 2 date?
The function you need is NETWORKDAYS. Look it up in Excel help.
-- David Biddulph "Cam" wrote in message ... Hello, What formula or how do I calculate number of days between 2 date excluding weekend and holiday? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculation between 2 date?
On Apr 17, 1:22*pm, Cam wrote:
Hello, What formula or how do I calculate number of days between 2 date excluding weekend and holiday? Thanks Cam, You are looking for Networkdays(x,y,z) Where x is the first date and y is the second date and z is either empty or a list of holidays. Jay |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculation between 2 date?
On 17 אפריל, 21:22, Cam wrote:
Hello, What formula or how do I calculate number of days between 2 date excluding weekend and holiday? Thanks networkdays(start_day,end_day, holydays) you have to have analysis toolpack |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| End Date Calculation (adding a start date duration) | Excel Discussion (Misc queries) | |||
| date calculation | Excel Worksheet Functions | |||
| Tricky Date calculation: How to calculate a future date | Excel Discussion (Misc queries) | |||
| Date Calculation | New Users to Excel | |||
| Date Calculation | Excel Worksheet Functions | |||
Hybrid Mode
