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.

Thank you both for help! I have a question to @Xlent:
According to screen, I should copy formula into D2 instead of C3, right? I did that and It's almost perfect, but, my fault sorry, I didn't show in example that Values can repeat in same Name range. That resulted in errors:
example2.png
Any way to fix this?

Originally Posted by Pojzon

...I have a question to @Xlent... I should copy formula into D2 instead of C3, right?

Yes, sorry about that.

...It's almost perfect, but, my fault sorry, I didn't show in example that Values can repeat in same Name range.... Any way to fix this?

Yes, minor change - highlighted in red below

=IF(OR(B2="";AND(A2=A1;B2=B1));"";IF(OR(A3<>A2;B3<>B2);C2;LOOKUP(2;1/(A3:A$29=A2)/(B3:B$29=B2)/(B2:B$28=B2);C3:C$29)))

Thank you, it fixed one problem, but I was hoping that it would work in that way:
example3.png
That it would see blank cells between Values, even tho these are both Value1. Right now it shows 2020-05-08 in both cases. Is that possible?

perhaps:

D2:
=IF(OR(B2="";AND(A2=A1;B2=B1));"";IF(OR(A3<>A2;B3<>B2);C2;INDEX(C3:C$29;MATCH(1;INDEX(SIGN((A3:A$29<>A2)+(B3:B$29<>B2));0);0)-1)))
copied down

if that doesn't work - please post a further sample file with more scenarios.

Amazing, seems to be working flawlessly. Thank you very much for help and sorry for being pain in the ***.