Forum Discussion
Continuous Date
You can do date math quite easily. (By the way, the term "continuous date" isn't one I recognize...you use it as if it's common speech).
From what you're showing, if it's the '16 days" you want to have calculated, you could simply enter the formula =D1-C1 (assuming columns begin in your layout with A)
If, on the other hand, you want to know what date is 16 days after 12/15/2020 (and that latter date is in cell C1), just enter the formula =C1+16
Your second sentence doesn't really make sense. Oh, maybe you're saying you want a field to read
12/15/2020--9/30/2021
Now if that's the case, that gets a little tricky but here's how to do it.
=CONCATENATE(TEXT(C3,"mm/dd/yyyy"),"--",TEXT(D3,"mm/dd/yyyy"))
assuming the first date is in C3, the second in D3.
mathetes 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?
Not totally. Your spreadsheet gives data, but what would really be helpful is to take that raw data and use it to illustrate what you mean by "continuous without a break" --illustrating it both ways --
The consolidated date is, I'm going to presume unless you correct me, is what I gave you in my first answer. Not really what I'd call a "consolidated date" (it is, after all, two dates) but a single text field that has concatenated (strung together) two separate texts, each of which is a date, with a separator. If that's what you mean, then you have that formula. If it's not what you mean, what do you mean?
mathetes I attached an update with what I'm seeking to accomplish in column E (showing continuous data). If the previous end date is 02/17/2021 and the new start date is 02/19/2021, then it's not continuous. A gap, or a break is there and it shouldn't calculate. However, if it's continuous, then the new end date replaces the old end date.
