End date for recurring events which happens few times a week.

[Revmatcher]

Hello everyone!

I have tried Googling and searching this forum for this answer to no avail so I was hoping that someone could help me figure this one out since I can't seem to do so.

I am trying to figure out the following.

I have a start date for a few events happening during a week. Lets say each event happens individually each day through out the week excluding weekends. So Event 1 happens Monday, Event 2 happens Tuesday, Event 3 happens Wednesday, Event 4 happens Thursday and Event 5 happens Friday.

There are 14 Event 1
There are 45 Event 2
There are 17 Event 3
There are 3 Event 4
There are 60 Event 5

What I want to know is the due date for each one of those events.

So if "Event week" started Monday May5th, what date would Event 1 end considering it happens 14 times and on Mondays? and Event 2? 3?etc...

I have tried a couple of formulas but non of them seem to do what I need.

Any help would be appreciated.

Thank you!

Rev.

 

[Revmatcher]

Yes it did! You are a true wizard, I would have never figured that out.

A million and a half thank you's

Rev

 

[Redwolfx]

Glad to help. Thanks for the feedback.