Forum Moderators: open

Message Too Old, No Replies

Calculate number of working between two dates

         

aspdaddy

5:11 pm on Dec 6, 2005 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Does anyone have a working function that does this, not holidays etc just the number of weekdays M-F between two days.

Thanks

jitendra baisakh

1:20 pm on Jan 2, 2006 (gmt 0)



//JAVASCRIPT FUNCTION

//TO CALCULATE WORKING DAYS

//TRY THIS OUT...DEFINITELY IT WILL WORK...

function calculateWorkingdays(startDate, endDate)
{
var stDate = new Date(startDate);
var enDate = new Date(endDate);
var startDateYear = stDate.getFullYear();
var startDateMonth = stDate.getMonth();
var startDateDat = stDate.getDate();
var endDateYear = enDate.getFullYear();
var endDateMonth = enDate.getMonth();
var endDateDat = enDate.getDate();

ssDate = new Date(startDateYear,startDateMonth,startDateDat);
eeDate = new Date(endDateYear,endDateMonth,endDateDat);if (ssDate > eeDate)
{
return -1;
}
workingDays=0;
while (ssDate <= eeDate)
{
if(ssDate.getDay()!=0 && ssDate.getDay()!=6)
{
workingDays++;
}
ssDate=new Date(ssDate.valueOf()+86400000);
}
return workingDays;
}

//CHEER UP!
//THANKS,
//JITU

aspdaddy

6:51 pm on Jan 2, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Thanks Jitu. I have sent you a sticky.