Calculation between 2 date?

  • Thread starter Thread starter Cam
  • Start date Start date
C

Cam

Hello,

What formula or how do I calculate number of days between 2 date excluding
weekend and holiday? Thanks
 
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
 
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

How to calculate the number of days between two dates 2
Template for calculating different number of days between 2 dates 1
Calculate date difference exclude Wkend 4
Calculate times between dates and times in Excel 1
time interval between dates incl weekends excl holidays 7
Date + X days excluding holidays 1
Formula for finding Date difference between 2 dates 4
Date calculation cell became #NAME?. 1

Back
Top