jackfox68
Board Regular
- Joined
- Jan 24, 2010
- Messages
- 121
Good day,
My SUMIFS statement is referring to a cell/range with a "=text" formula that converts a date into a day of the week, i.e. =TEXT(A1,"ddd"). Essentially what I am trying to do is sum all of the days in January that are not Saturday, and then divide them by the number of days that have past that are also not Saturday. Then I need to multiply the result by the number of the days in the month of January that are not Saturday. I am essentially trying to trend out the monthly call volume, however I need to calculate Saturday's differently because the hours of operations is only a 1/3 of what Mon-Fri is.
Column A is the Month/Year
Column B is the Day
Column C is the Day#
Column D is the Short Date
Thanks
Brian
My SUMIFS statement is referring to a cell/range with a "=text" formula that converts a date into a day of the week, i.e. =TEXT(A1,"ddd"). Essentially what I am trying to do is sum all of the days in January that are not Saturday, and then divide them by the number of days that have past that are also not Saturday. Then I need to multiply the result by the number of the days in the month of January that are not Saturday. I am essentially trying to trend out the monthly call volume, however I need to calculate Saturday's differently because the hours of operations is only a 1/3 of what Mon-Fri is.
Column A is the Month/Year
Column B is the Day
Column C is the Day#
Column D is the Short Date
Thanks
Brian