I want to make this formula fully automated every time i update my data source. I dont want to enter the number of weekdays or weekend days in a month every time i update the data source. I feel like i am missing a formula to replace the denominator of the formula shown below. For example average weekday formula is total count / 17 days. avg weekend is total count of weekend / 7 days.
My goal is to graph these sub total averages .