We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

WORKDAY() Excel function in Lavastorm

Comments

2 comments

  • Avatar
    Infogix Support
    Originally posted by: awilliams1024

    Hi Maria,

    The dateAdjust() function does not take into consideration whether the adjustment period includes weekends so you would need to account for these days when determining the actual number of days to increment/decrement the start date by.

    Here is one way you could do this. It is relatively fast for smaller adjustments/number of records. However, due to the iterative nature of the adjustment mechanism used, there may be better ways of achieving this if there is a large adjustment period and/or many input records.

    Adjust_by_Workdays--share.brg


    Btw, there is an in-built node that calculates the converse - the number of working days between two dates (i.e. equivalent of the Excel networkday() or networkday.intl() functions); this is the Calculate Workdays node in the Profiling and Patterns category.

    Regards,
    Adrian
    0
    Comment actions Permalink
  • Avatar
    Infogix Support
    Originally posted by: MariaB

    Thanks a lot Adrian!

    It works perfectly for now!
    Hope it will continue to work for larger data sets as I'm currently working on a small sample, but in the meantime I'll keep your solution
    0
    Comment actions Permalink

Please sign in to leave a comment.