Hello Marie Lieter,
I ran across your post when reviewing older unanswered posts. Did you find a solution for this issue?
Is it possible to share a workbook with the data as you show here and a few more rows of data and then share the expected output?
In the provided example - how is one to know that 3/13/2015 goes with 2/27/2015 vs going with the 1/23/2015 date? Is it just that it occurs after a previous datenewvalue?