Hi all,

Long time, no see. I am not sure how to approach this specific task and would like your feedback on this. I have a Month Calendar on my form. The automatic date is set to the current date. What I need to accomplish is to calculate the rescission date. The date is always three days in the future from the current date (excluding the current date); however, the amount of days in the future never includes holidays or weekends, so if there are holidays and/or weekends, these days are skipped from the calculation.

As an example. if today is 11/16/2014 and there are no holidays or weekends, the rescission date would then be 11/19/2014. If Monday 11/17/2014 was a holiday, then the rescission date would be 11/18/2014, etc.

If I recall, you can check to see if the date is a weekend, BUT, can you check to see if the date is a holiday? Maybe I would need to store these dates in a database?

Any ideas as to go about this?