5 Replies Latest reply: Dec 7, 2012 6:29 AM by Stefan Wühl RSS

    Last working day

      Hi everyone.

       

      I would like some help trying to create a variable for the last working date. It must also include public holidays which i already have in a spreadsheet.

      I am trying to add a button in my application for LWD (Last Working Day) which when pressed the date selection changes to the last working date.

       

      My fields are :

       

      [Event Date]

      PublicHols

       

      I know there is a function NETWORKDAYS but i don't know where to start...

       

      Any help would be appreciated.

       

      Thanks