Calculation between 2 date?
 

Hello,

What formula or how do I calculate number of days between 2 date excluding
weekend and holiday? Thanks

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

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

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