Calculation between 2 date?

C

Cam

Hello,

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

jlclyde

Hello,

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

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
 
A

AG

Hello,

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

networkdays(start_day,end_day, holydays)
you have to have analysis toolpack
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate date difference exclude Wkend 4
Date calculation cell became #NAME?. 1
time interval between dates incl weekends excl holidays 7
Calculate between two dates 3
Alternative formula to exclude holiday calculation 6
calculate number of days formula 11
Formula for finding Date difference between 2 dates 4
Date Value Error 6

Top