TIme Sheet Restricting Entry to only allow 5 workdays instead of 7

[opera6th]

Hello,

I am setting up a time sheet for my employers to use. There are 7 days in a week but I want to set it up in such a way that the user can only input work hours for 5 days a week and prohibit them from inputting anything on the other 2 days. For example, if Employee A worked Mon-Fri, then the user (employer) can enter the work hours for Mon-Fri but are not able to enter work hours for Sat and Sun. I want those cells to be inactive/prohibited.

Is there a formula where if ANY 5 cells are active, the other 2 will be inactive/prohibited?

This is super hard.

 

[dmartin35]

You can use data validation. I am assuming they are entering the number of hours they work on each day. If the days of the week are in columns A to G on row 4 then highlight the cells and enter the below formula in the formula box of the custom criteria.

=COUNTA($A4:$G4)<6

There are many other options with data validation to customize the error message, etc.

https://support.office.com/en-US/Ar...2c1-9d76-eff3ce5f7249?ui=en-US&rs=en-US&ad=US

Hope this helps,
David

 

[opera6th]

Thanks, David. Actually, it's the number of days they can work per week. So, they can only work 5 days a week. Hence, I would like a data validation that only allows 5 cells to have input (for 5 days a week) and an error alert to prohibit the user from entering data in the other 2 cells. Does the formula above still work?

 

[dmartin35]

If I understand you correctly, then yes. Put Sun - Sat in columns A-G and set up the data validation. If you enter something into columns A-E, when you try to enter something in column F the data validation won't let you.