Indirect / Array

**seanrigby** · 03-03-2010, 06:46 PM

formula is

=MAX(0,SUM(INT((WEEKDAY(MAX($A3,D$2)-{2,3,4,5,6})+MIN($B3,E$2)-MAX($A3,D$2))/7)))

How to change the array "{2,3,4,5,6}" based off a value in Cell f10?

**martindwilson** · 03-03-2010, 06:49 PM

what does this do?

**darkyam** · 03-03-2010, 06:54 PM

Also, "How to change the array "{2,3,4,5,6}" based off a value in Cell f10?" is very vague. How do you want to change it? Perhaps seeing a sample workbook with an example result would be best.

**seanrigby** · 03-03-2010, 07:24 PM

{2,3,4,5,6} is in regards to Monday, Tuesday, Wednesday, Thursday, Friday. If the week is Friday, Saturday, and Sunday, the array would be {6,7,1}

The array of the week's days could change, based off the individual person, so that is why the array needs to be somewhat flexible.

Hope this explains it more.

**DonkeyOte** · 03-04-2010, 04:22 AM

Sean, please pick a thread and stick to it.

http://www.excelforum.com/excel-gene...month-end.html

which do you want to continue with ?

(ie I was looking at the other thread and then came across this)

**seanrigby** · 03-04-2010, 10:24 AM

Appologize. Thread was getting way down the list, and was afraid that it wouldn't be seen.

**DonkeyOte** · 03-04-2010, 10:35 AM

In general terms you can "bump" your thread back up after a respectable amount of time (generally a good few hours - ie nearer a day) - this is done simply by replying to it yourself (eg "bumping").
Duplicate posts on the other hand will invariably get closed by Mods.

It's up to you what you want to do in this context - given the main purpose of your prior thread was accounted for a new thread is not necessarily a no-no but if you opt to pursue this you should mark the other as solved and retract the follow up question from it (replace perhaps with a link to this).

Generally where a thread has had a number of posts etc others who have not posted to it previously will generally not look in on it (assuming it to be "in hand").