Calculating The Number Of Days Between Dates

aveenm293

Forums

Hi Brian
I trust that you are well? I am trying to calculate the number of days between two dates (inclusive). I have used @age and this works fine. However is there a way to exclude Saturday and Sunday from the calculation? Also I need to exclude certain public holidays as well. Is this possible through a custom script or function? I would like to input the public hoilday dates or I can even code them in. I am using IDEA v8.5.
Thank you in advance!
Regards
Aveen
 
 

scotchy33 Mon, 06/08/2020 - 12:41

Hi Dianir,
You could modify the original custom function and input the public holiday dates where it is highlighted in the image attached.
Scott