I am wondering if I could use department member hire and release dates (busy paid on call department with high turnover rate) to get a snap shot from year to year.
At any given time, we have x members. If I know the dates they were employed with us, can I use a formula to pull up who was a member on y date?
For bonus, can I make it spit out the members years of service at that y date?
Any help would be grateful