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...
HansVogelaar
Jun 21, 2024MVP
In C2:
=SUM(--(DATEVALUE(LEFT(A2:A6, 10))<B2))
If you do not have Microsoft 365 or Office 2021, you may have to confirm the formula by pressing Ctrl+Shift+Enter (Windows) or Command+Shift+Return (Mac)
- jvella13Jun 21, 2024Copper Contributordates are all in cell A2 and not spread out A2:A6. each line within the cell does begin with the date. there are cells with multiple lines from 2 lines to 32 lines