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...
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)
I am glad you found a solution :).
Wish you a nice day.
Nikolino
I know I don't know anything (Socrates)