I am trying to calculate how many people are on a waiting list or still on the waiting list at the end of the month. Ex. If 5 people are waiting in Jan and then in Feb 3 people get added to the list and one person in Feb gets off the list then at the end of Feb my count should be 7. I do have people on the list for over 365 days. So I need month and year.
My dates are in mm/dd/yyy . variables are dtlist(date went on list), dtofflist (date they went off list).
Any help would be appreciated.