Help with calculation with 2 variables
I am looking for a calculation or formula to help me send out information at different intervals. I have clients that need to receive emails weekly or semi weekly depending on how many days are left before travel. For example a client needs 13 different emails over a 92 day span (date of contact - date of arrival), emails should be sent out on Thursdays on a regular basis. Or a client needs 18 different emails but only has a 36 day span. Emails then could be sent out on Mondays as well as Thursdays. Coding and logic are not my forte so I may have some follow up information if needed. Thanks.