You need to sign in to do that
Don't have an account?
MattMet86
Get # of days for week number X
Is there a way to get the total days or hours of each week of a month?
I am using WEEK_IN_MONTH() to get the week number but now I need something like HOURS_IN_WEEK() or DAYS_IN_WEEK() which I can use to generate hours.
For example, looking at January.
1st week has 4 days = 96 hours.
2nd week has 7 days =168 hours,
and so on,
Last week has 6 days = 144 hours.
I am using WEEK_IN_MONTH() to get the week number but now I need something like HOURS_IN_WEEK() or DAYS_IN_WEEK() which I can use to generate hours.
For example, looking at January.
1st week has 4 days = 96 hours.
2nd week has 7 days =168 hours,
and so on,
Last week has 6 days = 144 hours.