Calculate the number of mondays in a dynamic time frame

[Cyankee]

Ok, so the title might be confusing.

I play the lottery a little bit. What I am trying to calculate is the end date based upon the number of drawings I purchase.

Taking the two everyone is most familiar with Powerball and Mega Millions

If I purchase tickets today(2/8/15) for four draws on each game. I can look at a calendar and figure out the last play date, but, I would like to calculate it in Excel.

I have worked out the start date, it is a rather large formula, but I got it.
How do I get the last date?
Powerball draws on Wednesday and Saturday which makes the last date to be 2/21/15
Mega Millions is on Tuesday and Friday which makes the last date to be 2/20/15

If I purchase on the same day all the time, it would not really be a problem, but I do not and I also will not purchase the same amount of drawings each time.

Thanks

 

[barry houdini]

Which version of Excel are you using? If you have Excel 2010 or later you can customise WORKDAY.INTL to give an end date for any combination of days, e.g. for Wednesday and Saturday

=WORKDAY.INTL(A2,4,"1101101")

Where A2 contains the purchase date and where the "1101101" represents the 7 days of the week (starting with Monday) and the zeroes are the days to be counted.

So Tuesday and Friday would be "1011011"

If you want to include the purchase date in the count then use A2-1 as the first parameter

 

[Cyankee]

Great! Works perfectly!

I thought it would also work for the first day of the drawing and it does. Just changed the 4 to a 1.

Thanks barry!