I have a spreadsheet with date ranges within a single cell is there a
way to search for a date within that range?

i.e.

seth Jan 1-16
fred Jan 17-31
steve Feb 1-15
tom Feb 16-28

Can I find who worked Jan 12. Running a search?

Can anyone help me.