Allocate a sum of money on a daily basis

[philiphales]

Hi
I had some great help on this, but there is a bit of a problem. I initially tried using Networkdays as there are holidays in my programme. I have added a few holidays into my example.

Funnily, I had attempted to add this request for additional help twice and obviously each time it has not appeared.

I was beginning to think I had been abandoned or that there is no possible answer.

 

[NARAYANK991]

Hi ,

See the attached file.

If you add more holidays to the list , you will need to revise the formulae by including the added holidays in the references.

Narayan

 

[Hui]

I9: =IF(OR(I$8 > $D9,I$8 < $C9,WEEKDAY(I$8) ={1,7}, IFERROR(MATCH(I$8,$D$22:$D$23,0),0)), 0, $G9)

Copy across and down as necessary

 

[philiphales]

Guys

Well, that did not take long, thanks. Not being an advanced user, it did not occur to me that there are so many ways to 'skin a cat' in Excel. Once you get hung up on what you think is a solution like Networkdays, you get that you cannot see outside the box!
This is a great site, glad I managed to find it. Hope you have a nice day.
Bucketing down here in the South of England!!