Value according to workdays, weekends and holidays

[Pr0metheus]

Hello experts,

I am fighting with excel to find out, how to automatically insert value into cells according to workday, weekend and holiday.

The following I have:

- column F, cells F3:F22 are holiday dates
- column A, cells A4:A33 are proper dates (i.e. A4 = 1.4.2018)
- column C, cells C4:C33 must have following values:
* if A4 cell is working day -> value of C4 is 16
* if A4 cell is weekend -> value of C4 is 24
* if A4 cell is holiday -> value of C4 is 24

Is it possible to make combined formula to automatically select correct value?

Thank you for your help

 

[Pr0metheus]

This formula seems to be OK, if I am right.

=IF(NETWORKDAYS(A4;A4;F3:F21);16;24)