To make a formula to calculate items sold by each sales person.

For formulas to work based upon dates, they need to be dates. Dates which are in fact Text need to be converted. Real dates in Excel are really serial numbers starting with Jan 1, 1900. So you are testing for numbers falling into a range.