**New**#1

## Excel formula for week day work hours?

So i have this excel formula to get the days of a month '=DATE(CONFIG!B3,CONFIG!D5,1)' I was wondering if there was a way to tag on a formula that based on if its a week day it would show the number of work hours (in this case 8) and if it was a weekend day it would show an X, any way to do this?

basically first row days of the month, which I got covered

second row right below each day the corresponding 8 or X respectively?

so when I change the month in the formula I wouldn't need to put the values for each day

any help is greatly appreciated!