Description:
That script is useful for find number of days between two dates with and without specific day (Sunday). That code take two date parameters then calculate total days between given dates.
<script>
//Given Dates
var sDate='4/28/2018';//mm/dd/yyyy
var eDate='5/1/2018';//mm/dd/yyyy
var startDate = new Date(sDate);
var endDate = new Date(eDate);
//get total sundays
var totalSundays = 0;
for (var i = startDate; i <= endDate; ){
if (i.getDay() == 0){
totalSundays++;
}
i.setTime(i.getTime() + 1000*60*60*24);
}
prompt("Total Sundays",totalSundays);
//******End******
//count days between two dates
function parseDate(str) {
var mdy = str.split('/');
return new Date(mdy[2], mdy[0]-1, mdy[1]);
}
function datediff(first, second) {
// Take the difference between the dates and divide by milliseconds per day.
// Round to nearest whole number to deal with DST.
return Math.round((second-first)/(1000*60*60*24));
}
prompt("Total Days",datediff(parseDate(sDate), parseDate(eDate)));
prompt("Total Days Without Sunday",datediff(parseDate(sDate), parseDate(eDate))-totalSundays);
</script>

0 Comments