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 located within another cell.
example:
appointments after 1/1/20196 months# appointments on or before 6 months07/25/2022 Follow up Appointment – By Phone – 1 of 2 – 30 MIN
11/10/2022 Follow up Appointment – By Phone – 2 of 2 – 30 MIN
04/03/2023 Med Check – Video – 30 MIN
05/02/2023 Med Check – Video – 30 MIN
05/30/2023 Med Check – Video – 30 MIN 11/19/2022(I want a formula that will return 2 here since 2 dates in column A are before the date in column B)
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 located within another cell. example: appointments after 1/1/20196 months# appointments on or before 6 months07/25/2022 Follow up Appointment – By Phone – 1 of 2 – 30 MIN 11/10/2022 Follow up Appointment – By Phone – 2 of 2 – 30 MIN 04/03/2023 Med Check – Video – 30 MIN 05/02/2023 Med Check – Video – 30 MIN 05/30/2023 Med Check – Video – 30 MIN 11/19/2022(I want a formula that will return 2 here since 2 dates in column A are before the date in column B) Read More
