Multiple dates in one cell?

[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!

 

[Jacob Skaria]

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

 

[MSW Intern]

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...?

 

[Gord Dibben]

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

 

[Jacob Skaria]

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

 

[MSW Intern]

Thank you. How do I set the cell to wrap text and row autofit?

 

[MSW Intern]

Thanks so much! That was very very helpful!

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