Calculate working days excluding sat and sun - updating script

Forum|Forum|2 years ago
June 8, 2023
1 reply
1024 views

Hey guys!

I have a query. I have 2 dates and a text box calclating working days excluding sat and sun. Everything is working well unless i enter start date as sat or sun, the calculation then starts adding that sat or sun also.

Example: (format: mm/dd/yyyy)

Begin date: 04/09/2023(sunday) - End Date: 04/17/2023(monday) so W.Days should be 6 excluding the start date sunday but unfortunately I'm getting 7 days. Same problem is occuring when i enter start and end date as sat and sun then the entire calculation is messing up.

I'm attaching the file and I'm not good with js, please if anyone can help me with the script

test.pdf

Acrobat SDK and JavaScript

This topic has been closed for replies.

Correct answer try67

Change this line:

if ((iWeekday1 > 5) && (iWeekday2 > 5)) iAdjust = 1; // adjustment if both days on weekend

To:

if (iWeekday1 > 5) iAdjust++; // adjustment if either day on weekend
if (iWeekday2 > 5) iAdjust++; // adjustment if either day on weekend

try67

Correct answer

Community Expert

Change this line:

if ((iWeekday1 > 5) && (iWeekday2 > 5)) iAdjust = 1; // adjustment if both days on weekend

To:

if (iWeekday1 > 5) iAdjust++; // adjustment if either day on weekend
if (iWeekday2 > 5) iAdjust++; // adjustment if either day on weekend

M

Misbah26921674vrapAuthor

Known Participant

something is not right here with only on calculation of friday, not sure about it

M

Misbah26921674vrapAuthor

Known Participant

@try67 can you help me please? I'm almost done and you solution did worked but now its just giving wrong calculation when I'm adding a date of Fridays 🥺

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded