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:
![Untitled.png]()
Expected:
![Untitled1.png]()
Thank you.
Costs.xlsx
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:
Expected:
Thank you.
Costs.xlsx
SpreadsheetsMicrosoft ExcelMicrosoft Office
Last Comment
abbas abdulla
ASKER
Hi,
Saturdays and Sundays are not working days.
There's also a worksheet named "Off Days" which indicate non working days.
Thank you.
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you for your suggestion.
You are welcomed
What days other than public holidays should be considered as non working days?