0

Business Days Between

Hi everyone,

sorry if this has been asked before (I've searched the forum and documentation and can't find a solution).

I have a need to be able to calculate business days between two dates (FINISH_DATE & START_DATE) obviously excluding weekends and holidays. Also, as we have offices worldwide I need the ability to calculate for US holidays as well as UK holidays.

Is this something that can be done using the Date CSV file or has anyone else had a positive outcome from this?

 

Thanks for any help!

Sam

3replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi Sam, one approach to solving this requirement might be to create additional columns in the Date.csv file to capture weekends + US, UK holidays flagged as a 0 or 1. Next, create a formula to calculate the "non-business days" between any two dates in your formula expression, excluding weekends and the US/UK holidays. It does require extending the Date.csv file manually.

    Reply Like 1
  • Hi Sam,

    Similar to what Ashwin explained in his comment, this video shows how you can handle this for US and UK holidays:
    - https://youtu.be/vNIzQYqSFdI

    Reply Like 1
  • Ashwin & Anurag, thank you so much for your help!

    Reply Like
Like Follow
  • Status Answered
  • 1 mth agoLast active
  • 3Replies
  • 45Views
  • 3 Following