Appointment Scheduler

[iwilli]

I schedule all clients on a spreadsheet so I can later do a mail merge and calendar import. All clients meet three times a year. I want to schedule the first appointment and have the subsequent two appointments automatically populate. Each mtg date has it's own column. The dates need to be 4 months apart but be on the same day of the week ei. Monday, Tuesday and so on. While I can get =EDATE() close with the four months I just can't figure out how to get it on the same day of the week.

 

[shg]

How about =a1+17*7

 

[iwilli]

S-
I tried it out and it seems to work. Can you explain how it works? Thanks again. That is awesome!

 

[sarakar06]

The short answer is No. The UPS truck’s route is fine-tuned for efficiency and timeliness. Every delivery is scheduled based on where it falls along the route; there no left turns that can add time to the route. Over the past four years, we have been listening to our 1,000+ customers. We have created a list of all their wants and needs and have built many of them into this new version.




Patient Appointment Scheduling

 

[iwilli]

Sarakar06-You have me at a disadvantage. your reply dosn't make sense to me. Could I be missing something? Could you have posted to the wrong post?

The short answer is No. The UPS truck’s route is fine-tuned for efficiency and timeliness. Every delivery is scheduled based on where it falls along the route; there no left turns that can add time to the route. Over the past four years, we have been listening to our 1,000+ customers. We have created a list of all their wants and needs and have built many of them into this new version.