Know the start date - need to populate end date based on previous date

[Fortijo]

Hello and thank you for checking out my delimma.

I have a list of names with start dates but am missing end dates - like this:

I'm tasked with trying to have the dates populate something like this: 

I've tried everywhere I can think of - the biggest problem is trying to explain.  The ask was from another area and it is a nice break from my normal routine..but I'm stumped!  Can you help me?

Thank you so very much!

Josh.

[#2]

Hi @Fortijo 

Maybe something like this

File attached

[#3]

Thanks@Wyn Hopkins  I'll Give it a try!  I am also playing around with:

[#4 · Accepted solution]

@Fortijo 

Same formula but since I do not use reference by location (A1 notation) I introduced Names which refer to relative references

= IF( NextName=Name, NextStart - 1, FinalDate )

Better still the same formula works as a dynamic array formula (or CSE array formula if one so chose) if the names are redefined to apply to the entire range (offset by 1 cell where relevant).