Displaying two dates in excel
 

I am trying to display two dates in one cell in excel.

I have used the formula :

=DATE(YEAR(NOW()),MONTH(NOW()),I1) & " & " & DATE(YEAR(NOW()),MONTH(NOW()),I15)

Where the values of I1 and I15 are 1 and 15 respectively. The reason I chose this formula is becasue I want each date to diplay the 1st and the 15th of the current month. I would like this cell to read "7/1/12 & 7/15/12" however right now the current formula is giving me "41091 & 41105" I have formated the cell to display the correct date format that I want. Is there a way to fix this?

Hi, How about:

=TEXT(DATE(YEAR(NOW()),MONTH(NOW()),I1),"MM/DD/YY") & " & " & TEXT(DATE(YEAR(NOW()),MONTH(NOW()),I15),"MM/DD/YY")