"andreas" wrote...
I have a spreadsheet which has employee name in one column and the dates they
worked in another column. I am looking for a formula I can write which will
count the number of days each employee worked consecutively. Any ideas?

Ambiguous.

Do you mean for each employee there could be several rows of dates in the
column containing dates, or would there be multiple dates, as text, stuffed
into one cell for each employee?

By counting the number of consecutively worked days, do you mean you need
the sum of consecutive workdays, so, e.g., 24-Jul, 25-Jul, 26-Jul, 30-Jul and
31-Jul would be 5 consecutive workdays, or do you want the number of the
longest set of consecutive workdays, in this example 3, or the number of the
latest set of consecutive workdays, in this example 2?