Autopopulate a calendar? - Cross month issue

I got a series of questions and thank for some experts I managed to solve all of them.

But now I got a new requirement to calculate the "working days" not only limited to a particular month, but this time to allow cross month calculation.

Please check the sheet "Calendar (Expected)" for what I try to achieve.

Current:

Untitled.png
Expected:

Untitled1.png
Thank you.
Costs.xlsx
trowaAsked:
Who is Participating?
 
abbas abdullaCommented:
Hi,
Here is my solution:
1. Create Table includes Public Holidays and off.
2.  make sure all entries in calendar are formulas that returns date and not value.
3. Use this formula to find the number of working days =NETWORKDAYS(B4,H4,PHolidays[Dates])

Check the attached file it will be more clear for you

Best regards,
Abbas Abdulla
Costs.xlsx
0
 
abbas abdullaCommented:
Hi,
What days other than public holidays should be considered as non working days?
0
 
trowaAuthor Commented:
Hi,

Saturdays and Sundays are not working days.

There's also a worksheet named "Off Days" which indicate non working days.

Thank you.
0
 
trowaAuthor Commented:
Thank you for your suggestion.
0
 
abbas abdullaCommented:
You are welcomed
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.