Sum only working dates

  • Resolved ravilkhuzin

    (@ravilkhuzin)


    3 years, 12 months ago

    How can i sum only working dates, without saturday and sunday weekend.

    How to change it: CDATE(fieldname1+3, ‘dd/mm/yyyy’);

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author codepeople

    (@codepeople)

    3 years, 12 months ago

    Hello @ravilkhuzin

    The plugin implements the WEEKDAY operation where number one represents the “Sunday”.

    The idea would be to sum the days one by one, checking the day of the week in every step:

    (function(){
var n = 0, result = fieldname1;
while(n<3)
{
result += 1;
if(AND(WEEKDAY(result) != 1, WEEKDAY(result) != 7)) n++;
}
return CDATE(result, 'dd/mm/yyyy');
})()

    Best regards.

    Thread Starter ravilkhuzin

    (@ravilkhuzin)

    3 years, 12 months ago

    @codepeople thanks a lot!

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Sum only working dates’ is closed to new replies.