Forum Discussion
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 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.
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).
3 Replies
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:
