This content has been marked as final. Show 2 replies
I have two files: ODBC and excel file of just holidays. I was able to calculate weekdays and exclude weekends from the ODBC file using the following formulas. Now I would like to exclude the holidays from the excel file. Please advise how that should be done using two different data sources.
DATEDIFF('week',[Event Start Date],[End Time]) *5
MIN(DATEPART('weekday',[Event Start Date]),6)
I read several discussions from the forum and still could not find a solution.