Day of Week Question (In Formula)

[morningglow16]

Hi guys, I'm trying a formula out for my worksheet:

WEEKDAY(MAX(D18,D17)+1-{Sheet1!I23;I24;I25;I27;I28;I29;I30})

and the i23:i30 would be either (if checked) 2;3;4;5;6;7;8, or all zeros, depending on days worked per week. I know the weekday function uses serial numbers, the cells in the formula are pulling numbers.

Why isnt this formula working? This is aggravating, I thought i had this figured out. Please lend a hand. Thanks very much.

 

[morningglow16]

I think part of the problem is that I cannot 'edit' anything inside the serial number brackets (2; - ;8) Does anyone know if there is anyway to allow the serial numbers in the formula to be edited by an outside cell? the I23's and etc keep coming back with the error that says I need to input a serial number in that part of the formula. This is so frustrating because I came so close. Can anyone help please?

 

[T. Valko]

I think part of the problem is that I cannot 'edit' anything inside the serial number brackets (2; - ;8) Does anyone know if there is anyway to allow the serial numbers in the formula to be edited by an outside cell? the I23's and etc keep coming back with the error that says I need to input a serial number in that part of the formula. This is so frustrating because I came so close. Can anyone help please?

Well, all I can tell you is that in your formula you can't use cell references in an array constant.

I'm not too good with date formulas but if you can describe what you're trying to do maybe someone will be able help.

 

[morningglow16]

Thanks for the response. I have 1 worksheet that has days of the week worked by my employees (entered by checkboxes) those checkboxes have cells assigned to them indicating true/false.

I am trying to make a universal formula that would use like 2;3;4 for monday-wednesday, or 2;3;5 for monday, tuesday, thursday. How would I do this? Thanks.