Thanks for your reply Here is the dataset have for testing. My dates are SAS dates. data have; infile datalines dlm=','; input Task $ Start_Date: DDMMYY10. End_Date: DDMMYY10. Task_Hours; datalines; A,02/08/2018,11/10/2018,200 B,06/02/2019,19/02/2019,30 C,01/11/2018,05/02/2019,100 ; I was thinking of needing to write a function to encapsulate the the holidays dates along with the intck(Weekday,start,end) function. Something which mimics the excel function NETWORKDAYS. Your suggestion of just creating a dataset of holidays would work too.
... View more