Checkbox Question

[morningglow16]

Hey guys, long time lurker first post! I have a question with a spreadsheet i'm working on..how do i work a series of checkboxes (for days of the week) into a payroll formula.
if the employee works monday and wednesday, i only want to pay them for those days every week, only those checkboxes would be checked. How would i insert the checked boxes into a formula (using day of week serial number formula)?
i hope i'm explaining the question properly. i'm using form checkboxes by the way

 

[mikerickson]

The easiest way to incorporate a checkbox into a formula is to link the checkbox to a cell and use that cell's value in the formula.

 

[morningglow16]

yes that's what i have done, it shows the true/false value cells under the checkbox cells. how would i work the true/false values into a day of the week formula? does excel have the capability to differentiate days of the chosen days of the week? thanks for the response.

 

[morningglow16]

i think i have most of it figured out, but how would i put a if/then function in my formula? as of now, for mon-thurs i have:

'1-{2;3;4;5}' <- using the weekday function

using the formula as it's based, how would i say enter in, if monday box (checked) is true, than 2 (using the weekday serial number system)? if i can get this figured out, the rest of my formula i think will work. thanks again.