Weekday, Public Holiday function

[bnwash]

If it had the following

Col a Col B Col C Col D
Start date Finish date No of Days No of Weekends
[S & S]


I am looking for the code for Col d

regards

Barry

[oldchippy]

Hello Barry,

Take a look at this link on NETWORKDAYS, that should help.

http://www.bettersolutions.com/excel...A111880331.htm