Link to home
Create AccountLog in
Avatar of trowa
trowa

asked on

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:

User generated image
Expected:

User generated image
Thank you.
Costs.xlsx
Avatar of abbas abdulla
abbas abdulla
Flag of Bahrain image

Hi,
What days other than public holidays should be considered as non working days?
Avatar of trowa
trowa

ASKER

Hi,

Saturdays and Sundays are not working days.

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

Thank you.
ASKER CERTIFIED SOLUTION
Avatar of abbas abdulla
abbas abdulla
Flag of Bahrain image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of trowa

ASKER

Thank you for your suggestion.
You are welcomed