Forum Discussion
jvella13
Jun 21, 2024Copper Contributor
compare several dates in a single cell on multiple lines to a single date in another cell
Hi, I have a sheet that lists appointment dates on separate lines within a cell. I want a formula that will count the number of dates that appear in the cell that occurred before a specified date loc...
jvella13
Jun 21, 2024Copper Contributor
would it help if i were able to reduce the cell data to only the dates without line breaks?
go from this:
"06/24/2022 Follow up Appointment - Video - 1 of 2 - 30 MIN with Joe Brown, M.D.
08/11/2022 Follow up Appointment - Video - 2 of 2 - 30 MIN with Joe Brown, M.D.
09/02/2022 Med Check - Video - 30 MIN with Joe Brown, M.D.
11/02/2022 Med Check - Video - 30 MIN with Joe Brown, M.D."
to this:
"06/24/2022 08/11/2022 09/02/2022 11/02/2022"
go from this:
"06/24/2022 Follow up Appointment - Video - 1 of 2 - 30 MIN with Joe Brown, M.D.
08/11/2022 Follow up Appointment - Video - 2 of 2 - 30 MIN with Joe Brown, M.D.
09/02/2022 Med Check - Video - 30 MIN with Joe Brown, M.D.
11/02/2022 Med Check - Video - 30 MIN with Joe Brown, M.D."
to this:
"06/24/2022 08/11/2022 09/02/2022 11/02/2022"