Business Days Between
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!
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