Hi All,
I need help for this scenario. I had a date range in column which show the number of hours. I would like to sum up the data but to exclude holidays. I tried formula below
=IF(NETWORKDAYS($B$3,$F$3, $K$3),SUM(B4:F4)) but the return value is full range without to exclude the holidays.
Bookmarks