Displaying two dates in excel

[pooljunkie912]

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
chose this formula is becasue I want each date to diplay the 1st and th
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 tha
I want. Is there a way to fix this

 

[Spencer101]

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
chose this formula is becasue I want each date to diplay the 1st and th
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 tha
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")