Networking days separated bu months

[Ingolf]

Hi,

Need a little help with a formula (or VBA, or both) for that:

In column A starting with A2 is date (A1 = Start date), in B1=End Date, in C1, D1..... are name of the month like IAN, FEB.....Dec
In columns C2, D2....need a formula to show how many working days are in that months.
That days must be without Saturday and Sunday and holidays.

Thank you.

[Richard Buttrey]

Hi and welcome to the forum Have you tried

Please Login or Register  to view this content.

This assumes A1 is the first day of the month and B1 the last.
If A1 is any date in the month and you still want the number of days in that month then

Please Login or Register  to view this content.

[FlameRetired]

I interpreted a little differently and may have over complicated.

Please see attached.

With Start/End dates in A:B, each month across row 1 and holidays in AA1:AC2 this in C2 filled down and across.

Please Login or Register  to view this content.

[Ingolf]

Richard,
Thanks for reply but we need for many months like Dave solution.

Dave,
Yes, your solution is what we need. Excellent, thank you very much.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[Richard Buttrey]

Richard,
Thanks for reply but we need for many months like Dave solution.

.

It was just an example of one date range using Network Days which I presumed you would apply to all columns and dates
Another option would be in C2 copied down

Please Login or Register  to view this content.

and in D2 copied down and across

Please Login or Register  to view this content.

late edit. Just realised that since you mentione holidays you need to create a holiday range of dates and include that range as the 3rd (optional) parameter in the NetworkDays() function