Forum Discussion
Displaying a Date range based on another cell
Hi I was just wondering if anyone could help me figure out how to display a date range in a spread sheet in a single cell based on another cells value? I would like the third date row to be able to d...
I hope that I have understood the translation and the problem correctly,
here is a small suggested solution.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
NikolinoDE Hi! So I actually Solved the problem via this formula:
=TEXT(D9+1,"m/dd/yy")&" - "&TEXT(D9+8,"m/dd/yy")
Column D is the column labeled "date".
To get the other column to display the dates I used this formula:
=TEXT(D9+1,"dddddd")&"-"&TEXT(D9+8,"dddddd")
Hope this helps!
- If this formula suits you better, fine with me.
I am glad you found a solution :).
Wish you a nice day.
Nikolino
I know I don't know anything (Socrates)
