I have a highly-evolved workbook used for keeping track of many aspects of a 100-person Powerball and Mega Millions lottery pool that I run for friends and acquaintances. Many of that workbook's best features have come from answers to questions posted here, so thanks to all for their help so far. Now I need something else.
The lottery pools run from date X to date Y, usually about 13 weeks apart. During the period between those dates, there are lottery drawings every Tuesday, Wednesday, Friday, and Saturday. I need a way to tell how many drawings, total, take place between date X and date Y.
The idea is there will be three cells in a row on a worksheet. Cell #1 will contain the start date (date X), cell #2 will contain the end date (date Y), and cell #3 will contain the total number of drawings during the pool. My problem is how to get cell #3 to do what I want it to.
It looks to me like some sort of user-defined function might be useful here, and might even already exist. (I've dabbled in these, but it's been a LONG time since I last touched them.) Arguments of the function could be start date and end date. The function could return seven values (can functions do that?): Number of Sundays between start date and end date, number of Mondays, number of Tuesdays, etc.
Any sort of guidance, solution, etc. will be greatly appreciated. (And if we ever win a Jackpot, we will certainly make a BIG donation to this forum).