Struggling with Timesheet Formulas: How to Adjust Off Days from Friday to Saturday?

Parwiz
I am using a timesheet in my office, which is attached. I have a formula problem for the days. Off days are colored. When you change the Month No. on the Month sheet, the colored columns change their places according to the month days.

Formula Adjustment for Off Days

My problem is how can I change this Friday to Saturday, or how can I do it for both Friday and Saturday? Please instruct me on the formula!

Many thanks in advance!

Regards
1 Attachment(s) [Login To View]

Santosh.Gaikwad100
Hi Parwiz, I have checked your problem. Please find below the solution.

To Change the Color from Friday to Saturday:

1. Go to cell C11 in Sheet Hammad.
2. Select 'Format' -> 'Conditional Formatting' (Alt+O+D).
3. Change the formula from 'Fr' to 'Sa'.
4. Click on 'OK'.
5. Now copy the cell 'C11' and paste it to 'C11:AH15'.

To Change the Color for Both Friday & Saturday:

1. Follow steps 1 & 2 above.
2. Click on the 'Add >>' button.
3. Select 'Formula Is'.
4. Type the formula =C$9='sa'.
5. Click on the 'Format' button and select the Pattern/Font color required.
6. Click on 'OK'.
7. Now copy the cell 'C11' and paste it to 'C11:AH15'.

I hope this will help.

Regards,
Santosh Gaikwad
[Email Removed For Privacy Reasons]
[Phone Number Removed For Privacy Reasons].
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute