Get days between two business days

Answered

Comments

2 comments

  • Avatar
    Kirk Peterson (Edited )

    You'll probably get a better answer, but I'd try using WeekOfYear() and YearDiff() to subtract an appropriate amount of weekend days.

     

    Something like this (untested):

    DayDiff(A,B) - 2 * ((WeekOfYear(B)+YearDiff(A,B)*52)-WeekOfYear(A))

    1
    Comment actions Permalink
  • Avatar
    José Manuel Flores Medina

    Thank you!! It helped me a lot! 

    Again thank you very much for your help.

    1
    Comment actions Permalink

Please sign in to leave a comment.