Thank you for your response! I'm going to study this and give it a try. PIPE was the first option I found when I was searching and trying to figure out how to do this.
... View more
I rarely do this, and not sure I have time for it, but can you email me the full file via DM and I'll take a look? Include one or two variations and I can make some recommendations on how to refactor it for efficiency.
... View more
Thank you both! Both solutions give me the continuous index that I'm looking for --- but first solution is strictly referenced with respect to the calendar (e.g. month 2 begins when next calendar month after month of hire begins rather than 4 weeks after hire date) rather than a straight count index of number of weeks/months worked since date of hire (solution #2). Thank you for your help!
... View more
