Subtract 1 Day from the date value in the below row for each employee

[Kavya132017]

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!

[Christina_H · Accepted solution]

Use a multi-row formula, grouped by employee ID.  DateTimeAdd([Row+1:Start Date],-1,"day")