Storing multiple dates in one cell

[ajaxx66]

I want to preface this by saying that I am VERY much a novice Excel user (using Excel 2016). I am trying to create a client tracking list and one of the columns I have is "Date(s) of service". Every client will have a different number of services dates, which I would like to keep in the same cell, and only see the most recent date of service.

 

[The_Macrotect]

Hi ajaxx66,

I'm not sure I completely understand what you're trying to do. If you'd like to hide all of the dates except the first one in each cell, you could try highlighting all of the dates you'd like to hide in any particular cell and changing the font color to white. The data would still be there, and would show up in the formula bar at the top, but it would be invisible in the cell itself. Let me know if you're looking for something else.


All the best,
Matt

 

[Michael M]

Keeping all dates in one cell means you can't really do anything with them...filtering, sorting, formulas, pivot tables, charts.
While matts idea makes sense....i'd simply use a new column for each "Date of service"