Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Quote:
=TEXT(DATE(YEAR(NOW()),MONTH(NOW()),I1),"MM/DD/YY") & " & " & TEXT(DATE(YEAR(NOW()),MONTH(NOW()),I15),"MM/DD/YY") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dates displaying as General Data | Excel Discussion (Misc queries) | |||
Displaying text during a range of dates | Excel Worksheet Functions | |||
Chart Displaying Dates and Intervals. | Charts and Charting in Excel | |||
How do I get the dates on an excel chart to stay as dates instead. | Charts and Charting in Excel | |||
Displaying Dates | Charts and Charting in Excel |