making a schedule for Part time Employees

[VolleyScott1982]

I am trying to write a formula to check the day of the week and keep track of my part time employees shifts. I have two part time shifts, Monday to Wednesday, and Wednesday to Friday. I have a cell to have both the daily date and a cell to have the Day of the week. I also cave rows with checkboxes to determine if an employee is on a Mon-Wed shift, a Wed-Fri shift, or if they are Full time. I just want a cell for easy view to help me to check to see if they are supposed to be on the schedule for the day. That way I know if I need to call or write up an employee without wasting too much time. I was trying to use an "If then" formula, is that the best way, and can you help me?

This is the formula that I am using:
=IF(I2="2"OR("3"OR("4"AND(C2:C41=true,"yes"))))

Cell "I2" is what states if it is a Monday or other day of the week. and the "C" column is the Mon-Wed Shift check box.
I have hidden cells with employees info.

Broken Formula.png

[Estevaoba]

Welcome to the forum.

Try this in any cell in row 2 and copy down:

Please Login or Register  to view this content.

Good luck!

[VolleyScott1982]

Thanks for the formula, unfortunately it did not function properly with the check boxes.

[Estevaoba]

Not always is a checkbox linked to the cell they are in.
Please right click on a checkbox and select Format..., then find out what cell it is linked to and amend that argument in the formula.
If that does not work, please follow instructions on yellow banner above to upload a sample workbook.

[VolleyScott1982]

Added the spreadsheet, I made sure that the check boxes were linked to the cells they are in. still could not get formula to work. Thanks for all your help.

[Estevaoba]

Oh, I see what the problem is.
The text TRUE must go with no quotation marks. Sorry about that.

Please try:

Please Login or Register  to view this content.

And you can replace TODAY() in the formula with $H$2, so you can play with other dates and see the outcome.

[VolleyScott1982]

Looks like that did it. Thanks so much

[Estevaoba]

You’re welcome. Glad to help.
Thank you for the feedback and for the reputation added.
Have a blessed day.