I would like to count the number of appointments in a row that occur following a first appointment based on how soon after they occur (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, etc. are dates of subsequent appointments
A B C D E F
1 11/2/98 12/3/98 3/4/99 9/5/99 10/25/99
2
3
So for the sample above the counts for each category would be 1 appointment occurred within 90 days after 11/2/98, 1 occurred between 91-180 days after 11/2/98, and 2 occurred 271-365 days after 11/2/98.
I have attached a sample of what I'm trying to do. Suggestions?
Bookmarks