Forum Discussion
Continuous Date
I would like to use a formula that could use a specific linking factor such as a SSN/Name and would be able to dictate whether or not the dates are continuous without a break and give me a consolidated date. Any assistance is greatly appreciated.
11 Replies
I didn't understand what exactly you were trying to do.
It would be advantageous if you insert a file (without sensitive data) and explain your plans in detail with regard to this file.
Perhaps these examples will help you solve your problem.
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?
- Excuse me, but I'm not a specialist in Social Security Nummbers (SSN).
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)
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.
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?
