Getting data(amount of days) from a fixed calendar?

Hello everyone.
I would like to know that is it possible to take amount of working days per month from a fixed calendar?
Thank you so much…

Kindly have a view on this

Cheers @hsupyaewoon

1 Like

Thank you so much @Palaniyappan
It might work.
Is it possible to do with a fixed calendar that is created according to my rules?
I mean I would like to use a calendar that I created.
There may be not only sat sun and also other holidays.
I would like to count from the 1st day of a month and if it is an holiday, I won’t.
I want to count per week but in the every next week I will also add the numbers of the day that has been already counted.
I am sorry for my bad explanation.
Can you please tell me is it possible to do so?

Of course it can be done but with some logic
Kindly give us an example of how it would be for a month so that we can come with a logic to count them
Cheers @hsupyaewoon

1 Like

Sure @Palaniyappan
For example,

The first week starts on 1st Wed and ends in 3rd friday.
In this case, I would like to count also the next week.
So, it will be from 1st to 10th for counting the first week.(excluding sat sun)
(If the 1st day of this month is starting on 1st Tuesday, I won’t count the next week.(Means 1st to 4th only for counting the first week). I will count as a week if the amount of days is more than 3days, if not i will add days from the coming week.)

Then, for the second week, monday is holiday and so I will count from Tuesday.
But this time, I would add the amount of days that has already been counted in the last first week.
So, it will be from 1st to17th excluding the sat sun and holiday.
Also the 3rd and 4th weeks will be counted the same way.