Is this impossible?

[intheskywithdiamonds]

People always ask 'can i add x amount of days to a date excluding weekends/holidays?'

I want to know;

Can I add x amount of days to a date, excluding specific days of the week i.e mondays and tuesdays?

So if I want to add 20 days to a date but not count mondays or tuesdays? Is that possible?


Please help me!

All input appreciated

 

[intheskywithdiamonds]

Jonmo I appreciate your thoughts on this, i've been lost!

I'm going to give your solution a go now and i'll let you know if it is successful

Thank you again! I felt as though I had tried everything

 

[Jonmo1]

Here is an example of how I would do it.

The user selects their days worked in F2:F8. Yes = working, No = Not Working
The week MUST be in Monday through Sunday fassion.
The data can be entered in F2:F8 in any order you like, but the formula in G10 MUST go in order from Monday to Sunday.

LOL, here I'm adamant that it must go Monday through Sunday, yet I post it in Sunday through Saturday.

That should have had MONDAY in E2..