What is this formula doing?

[coppercarbide]

Hi all,

I made a sheet a long time ago and need to modify it a bit. One of the cells calculates how many work days are within two days, I had some help doing this one, and I'm using this formula:

=IF(J6="",0,SUM(INT((WEEKDAY(J6-{2,3,4,5,6,7})+K6-J6)/7)))

I need to modify this formula in order to be able to dynamically set whether Saturday is a workday or not (currently it is in the above formula).

If someone could explain what exactly this formula is doing, I should hopefully be able to figure out how to dynamically select the workdays.

Thanks!

 

[coppercarbide]

Wow.
It took me about 10 minutes of reading the explanation to figure out what was going on! That's extremely impressive.

I do like the IF with the array option, as it is a bit more elegant than what I ended up with. However, the one I wrote is already done, so I may keep that until I need to muck with it for some other reason.

Thanks so much, I'm going to definitely add this to my list of fantastic solutions for the future!