Calculation between 2 date?

[Cam]

Hello,

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

 

[David Biddulph]

The function you need is NETWORKDAYS. Look it up in Excel help.

 

[jlclyde]

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

 

[AG]

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