Forum Discussion
Continuous Date
NikolinoDE I would like to use a formula that could use a specific linking factor such as a SSN and would be able to dictate whether or not the dates are continuous without a break and give me a consolidated date. Does this make sense?
In the file, please explain in detail what exactly and in which cell what you want to accomplish.
Please keep in mind that we too are ignorant of the knowledge of others.
Should only the days be calculated. from start and end date?
If it is to be linked to SSN, then how?
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
NikolinoDE I would like the formula to use a specific linking factor and analyze the start and end dates and if they are concurrent and don't have a day gap. For instance, JANE DOE's end date is 12/31/2020 and her new start date is 01/01/2021, therefore the date is continuous and the old end date of 12/31/2020 is null and void and the new end date is 09/30/2021. The example for Jill Doe has a break after 11/30/2020, therefore I know it's not consecutive, but the next dates are in the realm of the aforementioned scenario.