Holiday calculation in Gantt chart

[salmanak]

Hi

I need some help with Gantt chart to calculate holidays, it now only calculation weekends only, file can be downloaded from here.

Thanks
Khan

 

[ace19852]

Welcome to the board

Had a quick look at your file and it seems to me in R18 you could have

=(NETWORKDAYS(P18,Q18))

instead of you long formula

and total weekend days would be

=Q18-P18+1-R18

Maybe I'm missing something

anyway Cheers

 

[salmanak]

Welcome to the board

Had a quick look at your file and it seems to me in R18 you could have

=(NETWORKDAYS(P18,Q18))

instead of you long formula

and total weekend days would be

=Q18-P18+1-R18

Maybe I'm missing something

anyway Cheers

Thanks Ace, but how can I mark them in red like marked for Weekend