Dec 12 2019 02:22 PM
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.
Dec 12 2019 03:19 PM
Dec 12 2019 03:29 PM
Thanks@Wyn Hopkins I'll Give it a try! I am also playing around with:
Dec 12 2019 03:42 PM
SolutionSame 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).
Dec 12 2019 03:42 PM
SolutionSame 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).