This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Scenario: I need to take the most recent year and back fill termination dates for the prior years of data. See Example:
the 2017-03-27 term date needs to be filled in the Null Gap between the 2015-04-02 and 2017-03-27 term dates. Then the 2015-04-02 term date needs to be filled all the way down for the remaining Null gaps. I have tried using a multi row formula but can't seem to figure it out.
all of the dates are grouped by the same unique ID and cascade down from 2017-2007 years.