Multiple dates in one cell?

  • Thread starter Thread starter MSW Intern
  • Start date Start date
M

MSW Intern

Is there a way to list multiple dates within one cell? I have a very complex
spreadsheet and can't afford individual cells for the one item that requires
multiple dates be input into it.
When I tried just listing more than one date, the numbers went over the cell
boundaries into adjoining cells. I need it to instead either wrap to a second
line within the same cell (making the cell longer) or do something similar
that doesn't affect the surrounding cells but keeps all the information. Any
help appreciated!
 
Try the below

Sub Macro()
Range("A13") = Range("A13") & vbLf & Date
End Sub

If you want to keep the height as such

Sub Macro()
Dim varHeight as Variant
varHeight = Range("A13").RowHeight
Range("A13") = Range("A13") & vbLf & Date
Range("A13").RowHeight = varHeight
End Sub

If this post helps click Yes
 
Where do I input that formula on my spreadsheet? If I highlight cell A13 and
type that in, then I'm not able to input the dates without erasing the
formula...?
 
You posted in programming group so Jacob gave you a macro.

Not to be entered into a cell.

You can have more than one date in a cell and wrap the cell's contents using
a formula.

=TEXT(TODAY(),"mm/dd/yy")&CHAR(10)&TEXT(TODAY()+1,"mm/dd/yy")

Set the cell to wrap text and row autofit.


Gord Dibben MS Excel MVP
 
To enter multiples line in a cell; enter data to a cell and without pressing
Enter press Alt+Enter and you can continue entering data.

To enter current date the shortcut is (Ctrl key + Semilon key)

If this post helps click Yes
 
Thanks so much! That was very very helpful!

Jacob Skaria said:
To enter multiples line in a cell; enter data to a cell and without pressing
Enter press Alt+Enter and you can continue entering data.

To enter current date the shortcut is (Ctrl key + Semilon key)

If this post helps click Yes
Click to expand...
 
Back
Top