Question

122

Getting Working Days Using Javascript

rated 0 times [ 123] [ 1] / answers: 1 / hits: 24845 / 13 Years ago, mon, october 31, 2011, 12:00:00

I'm trying to get the working days between two date.
Example: stdate = 28/10/2011 and endate = 04/11/2011. This should be 6 working days, but its only giving 5 days.

var workingdays = 0;

var weekday     = new Array(7);

weekday[0]=Sunday;

weekday[1]=Monday;

weekday[2]=Tuesday;

weekday[3]=Wednesday;

weekday[4]=Thursday;

weekday[5]=Friday;

weekday[6]=Saturday;



while (stdate <= endate) 

{

    var day = weekday[stdate.getDay()];

    if(day != Saturday && day != Sunday) 

    {

        workingdays++; 

    }

    console.log(weekday[stdate.getDay()]);

    stdate = new Date(stdate.getTime() + 86400000); 

}

The console log shows the results below.

Friday

Saturday

Sunday

Sunday

Monday

Tuesday

Wednesday

Thursday

Sunday shows twice for some reason. Any help would be appreciated.

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

anikas

Add To Favorites

Follow

Total Points: 258

Total Questions: 102

Total Answers: 95

Location: Monaco

Member since Sun, Jan 16, 2022

2 Years ago

anikas questions

1 Uncaught Error: MUI: makeStyles is not longer exported from @mui/material/styles

Tue, Sep 28, 21, 00:00, 3 Years ago

1 The requested module 'franc' does not provide an export named 'default'

Sat, Sep 11, 21, 00:00, 3 Years ago

1 How to properly add conditional class to Alpine JS x-for template?

Sun, Feb 28, 21, 00:00, 3 Years ago

1 Nuxt.js + Auth ( jwt refresh token )

Sun, Aug 16, 20, 00:00, 4 Years ago

1 Angular Validator check if input is number

Sun, May 17, 20, 00:00, 4 Years ago

View All

answered 13 Years ago marinalyssak · Accepted Answer

Daylight savings time.

As you are adding 24 hours to the date, it's not enough to get you to the next day on the sunday, as that particular sunday has 25 hours.

You should add a day instead of adding hours:

stdate = new Date(stdate.getFullYear(), stdate.getMonth(), stdate.getDate() + 1);

Explanation: When you call the Date constructor with a date that is out of range, it will automaticall wrap to the next month, i.e. new Date(2010,9,32) gives you the first of November.