Hi!

Here's one way but requires a helper column in addition to the column "In a
Row" Also requires an empty row immediately above the data.

Dates in column B. B1 is the header "Date of Absense" Row 2 is empty and the
actual dates are in the range B3:Bn

Helper column will be column C. "In a Row" will be column D.

Enter this formula in C3:

=IF(B3=B2+1,B2+1,1)

Enter this formula in D3:

=IF(B3+1=B4,D4,C3)

Select both C3 and D3 then copy down as needed.

Biff

"kingpenguin58" wrote in message
...
Is there a calculation (function) that will look in a row and return the
number of continuous dates in number format?

Sample:

Name Date of Absense In A Row
Doe, John 12/17/04 4
Doe, John 12/18/04 4
Doe, John 12/19/04 4
Doe, John 12/20/04 4
Doe, John 12/24/04 1
Doe, John 12/27/04 1

The number in the "In A Row" column should calculate off the "Date of
Absense" column as it looks down the row and sees the date change.

Any suggestion would be helpful.

Thanks!