Hey everyone,
I want to get 1 day minus of the value in next row for each employee.Attached the sample data..I need to derive "End Date" Column.
Thanks in advance!
Solved! Go to Solution.
Use a multi-row formula, grouped by employee ID. DateTimeAdd([Row+1:Start Date],-1,"day")
User | Count |
---|---|
63 | |
24 | |
23 | |
21 | |
20 |