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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Storing multiple dates in one cell
The_Macrotect
Board Regular
- Joined
- Dec 11, 2017
- Messages
- 111
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
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
Upvote
0
Michael M
Well-known Member
- Joined
- Oct 27, 2005
- Messages
- 21,898
- Office Version
- 365
- 2019
- 2013
- 2007
- Platform
- Windows
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"
While matts idea makes sense....i'd simply use a new column for each "Date of service"
Upvote
0
Similar threads
- Question
