Need help in getting the equivalent month of week

Databases
1

Hi…

I have 2 tables for week and calendar days.

first I have so_week
fields:
from_week
to_week

second is calendar_days
fields:
month_name
working_days

sample data:
from_week : 33
to_week: 36

month_name:
Jan
Feb
Mar
Apr
May
and so on

working_days:
23
22
25
25
23

now I need to get the working days based on from_week to week

for example from 33 to 36 the month is aug, sep, sep, sep i need to get the working days for that month.

any help is highly appreciated…

Thank you so much

2

it cannot be done with that data

3

why??

4

because

please explain how you would arrive at the right answer for weeks 33 to 36

5

If we’re talking about two random weeks, then it’s very simple. You only need to account for possible start of the year and end of the year incomplete weeks.
Otherwise, any week in between is a full week: 7 days total minus the 2 days week-end.

33: 5 days
34: 5 days
35: 5 days
36: 5 days

20 days total. Of course, you need to count down the legal holidays.

Unless you mean something else. Like between two random dates.

6

You would probably want to make a table of all the weeks in a year, and how many working days are in each week number.