1- I have select, which is supposed to return appointments that need notified bewteen today and the appointment date. Sounds simple, but, the appointments have a notification date...which depends on how many days in advance the client wants notified

2- and On top of that
holidays and weekends add to the days in advance.

thanks