Count if difference between dates <60days, 60-90days, etc.

[kayacsp17]

I would like to count the number of subsequent appointments that occur for a client within 4 time periods from an initial appointment date: within 90 days, between 91-180 days, 181-270 days, and 271-365 days.

Column A is client number
Column B is initial (appointment) date
Column C-F are appt 1 date, appt 2 date, appt 3 date, appt 4 date

I have attached a sample of what I'm trying to do. Suggestions?

[kayacsp17]

attachment

[NSA401]

There is nothing in this thread that helps anyone other than the person who submitted it. Would you please be kind enough to SHARE what the user's issue was, as well as how it was solved?
I, too, have a similar situation, and your answer might help others if it were simply published to the thread.

Regards!

[bebo021999]

Ready to help but there is no attachment to work with.

[NSA401]

My comment was directed at the originator and kayacsp17 who solved the issue - they did not share within the thread what the issue was, nor how it was solved. I have a similar problem, but since they did not respond with written text, only and "attachment", no one but them know what happened. I was merely asked them to share via written text how this issue was solved so it may be helpful to others (like me).

[Fotis1991]

As this is a 6-7 years old thread, i don't think that kayacsp17, will be able to helps you. So pls start your own thread as per forum rule#2.

. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

Thank you.