ExcelFanatic
Board Regular
- Joined
- May 22, 2009
- Messages
- 83
In my spreadsheet columns L through O contain dates:
L - Planned Start Date
M - Actual Start Date
N - Planned End Date
O - Actual End Date
In column P I an concatenating the dates to give me a start - end using the following:
=IF(M7190="",L7190,TEXT(M7191,"mm/dd/yyyy"))&" - "&IF(O7190="",N7190,TEXT(O7190,"mm/dd/yyyy"))
The result is not giving me the dates, just the number equivalent.
What am I missing?
L - Planned Start Date
M - Actual Start Date
N - Planned End Date
O - Actual End Date
In column P I an concatenating the dates to give me a start - end using the following:
=IF(M7190="",L7190,TEXT(M7191,"mm/dd/yyyy"))&" - "&IF(O7190="",N7190,TEXT(O7190,"mm/dd/yyyy"))
The result is not giving me the dates, just the number equivalent.
What am I missing?