Return specific dates of the month in one field

I need to have one field show all the dates that each customer was seen. For example, October 1,4,6,7,8.

I tried the concatenate function, but it seemed I needed the IF/then statement and there is a limit of 7.

Here is a screen shot:
Screen Shot 2013-10-14 at 5.05.25 PM.png

where J1 = the 1st of the month, K1 = the 2nd of the month, etc.

So Debbie Doe was seen on October 6,9

The month is in Field $E$105.

Thanks in advance for your help.
-D

Try this:

in standard module

Please Login or Register  to view this content.

All you need to do is click on a row where a person's name exists, you will get the result in a message box of when they were visited...

Otherwise, you can open the file I attached ...choose a cell in the row where a person's name exists, and click the button, messagebox will appear...

Here is another solution, this one updates all the records in the range "E8:E100" in column "AO" when the button is pressed:

Month in cell E105 and all the dates visited separated by a ","

Here is the code:

Please Login or Register  to view this content.

Thanks for your reply. I'm trying to see which solution will be best for me.

Thanks for your reply. I'm trying to see which solution will work best for me.