Hello, I need your help to do the following changes in this sheet:
http://exceltemplate.net/wp-content/...ly%20V1.1.xlsx

In cell D8 we have to select the working days. There are three options available there, Monday - Friday (5 days), Monday - Saturday (6 days) and Monday - Sunday (7 days). This information needed to calculate the project week duration (WD), days completed (DC) and days remain (DR). And it will be used also to give you the correct holidays mark inside the chart.
I need to add another option of "Saturday - Thursday" meaning Friday Holiday.

I can see in cell E8 the formula
=IF(D8="Monday - Friday",1,IF(D8="Monday - Saturday",2,3))
Can someone please help me to help here for me? All what I need is to use ""Saturday - Thursday" meaning Friday Holiday"