hi,

did you have a table with the holidays?

looking for Sun or Sat use IF function:

=if(or(b2="sat",b2="sun"),0,"")

note that when you will put the correct figure (i.é 15,23, etc) the formula
will be erased.

hth
regards from Brazil
Marcelo

"The Mole" escreveu:

I'm creating a work chart, and what i want to do is whernever appears Sat or
Sun, if week-off or holidays the result should be 0.

Dia Sem Ent SaÃ*d Ent SaÃ*d
1 6ª
2 Sab Folga
3 Dom
4 2ª
5 3ª
6 4ª
7 5ª
8 6ª 15 23 8
9 Sab 15 23 8
10 Dom 17 23 6