jahantech your prompt replies are really highly appreciated. very sorry to say but could you or anybody please help me with providing an example of this complicated code.
dear jahantech,the follwoing code worked like a charm!.... i just added "-1" in the end of the following line:var toDateAsNum =Date2Num(toDate, "YYYY-MM-DD", "en_IE")-1.
jahntech, many thanks for prompt replies..now it is showing 6 working days if a person leaves on 1 apr 2018 and back to work on (Date2) 8 apr 2018.i want it to show 5 days and two weekend days (Fri and Sat) .... keep in mind that Date2 is joining date which means that the total days should subtract ...
Want to get total days from two dates Date1Date2the total days should exclude weekends "Fridays" and "Saturdays"I'm pushing the script in properties of the Total field.could anybody check if I'm doing something wrong because the calculation is not showing the correct number.the code is given below:/...