I have an excel calendar that I used to track my therapists visits in home health. I have speech, occupational and physical therapists that see the same patient and I track their visits on an excel calendar already. What I would like to do is to have the calendar count up all of the scheduled visits and on the week of the 13th and the 19th visit (combined totals) it would highlight the week proceeding each of those visits(highlight back 7 days from the 13th and the 19th visit). If it is a simple task, how could I incorporate it into my existing calendar? (i am just learning excel) If it is not so easy, where could I go to get it done?

Thanks