Find date end for unique value.

Hello,
I'm trying to fill in column "Date_end" in this table:
example.png

Every Name will have same amount of rows (depends on month length), so I think that there is no need to check if Names match, Values and Date_start should be enough. Do you think that it's possible to do with formulas only or VBA is required? I'm also attaching file if someone would like to work with it. Thank you for any help.