Forum Discussion
Solved
Know the start date - need to populate end date based on previous date
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...
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).
ThanksWyn Hopkins I'll Give it a try! I am also playing around with: