Forum Discussion
kana723
Feb 14, 2019Copper Contributor
Count Cells with greater than Date, when Cells Contain Multiple Dates in Line Break w/ Custom Format
Hello everybody, I have cells containing names in text format and dates in a custom format: mm\/dd\/yy. Some cells contain multiple dates on separate line breaks within the cell. How do you co...
SergeiBaklan
Feb 14, 2019Diamond Contributor
Hi,
In column C you actually have mix of numbers (aka dates) and texts which only looks like dates. To check condition it's a bit complicated - check if the value is text or not; if text split on values separated by line feed, convert each such value to date, build sequence of all values and check if they are against criteria text in left column.
Perhaps it's easier to restructure your data to ensure one date per cell?