Hi Everyone,
I'm not familiar with networkdays formula, trying to calculate number of work days from Monday to Friday and Saturday is half workday.
I've created the formula but seem incorrect answer
=(NETWORKDAYS.INTL("5/5/2021","10/5/2021",1)+NETWORKDAYS.INTL("5/5/2021","10/5/2021",17)+1)*0.5
I'm not familiar with networkdays formula, trying to calculate number of work days from Monday to Friday and Saturday is half workday.
I've created the formula but seem incorrect answer
=(NETWORKDAYS.INTL("5/5/2021","10/5/2021",1)+NETWORKDAYS.INTL("5/5/2021","10/5/2021",17)+1)*0.5