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 need this in order to check SLAs for each week of the month.