Hello! I have a list of people who worked various time frames over the course of many years. So essentially each row looks like: NAME, ASSIGNMENT, START DATE, END DATE
NAME, ASSIGNMENT, START DATE, END DATE etc
The requirement is to determine the length of time that lapsed from one assignment ending, and the next assignment beginning.
Is there any way that I can reference the END DATE of the previous row, so I can perform a days_between or something?
Thank you in advance! 8)