2 dates in one cell

June 1, 2018 at 05:39:03
Specs: Windows 7
I have 2 Insurance dates in one cell how can I show when they expire if they are different dates? how do I get both dates to appear in the cell correctly to show on bar for corrections? The excel spreadsheet is very large and shared with others to update and view. Would be to difficult to put dates in separate cells.


See More: 2 dates in one cell

Reply ↓  Report •

#1
June 1, 2018 at 09:27:58
You can not have two dates in a single cell, Excel will only see them as TEXT strings not as dates.

how do I get both dates to appear in the cell correctly to show on bar for corrections?

Don't understand what your talking about here.

There are possibly ways you could cut out the dates from the single cell and convert them to real dates,
but we would need more information.

MIKE

http://www.skeptic.com/


Reply ↓  Report •
Related Solutions


Ask Question