Biff,

Thanks. What does "zzzzz" represent? Also, is there a way to use a HLookup?

Paul

"T. Valko" wrote:

Try this:

=IF(COUNTIF(D3:I3,"x"),TODAY()-LOOKUP("zzzzz",D3:I3,D2:I2),"no records")

--
Biff
Microsoft Excel MVP


"Pablo" wrote in message
...
I am trying to figure out how to determine how days it has been since
someone
last visited. I have a weekly attendance sheet that listed a class roster
in
column A3:A10. Running across the top D2:I2 are class dates 1/04/09,
1/11/09,
1/18/09, 1/25/09, 2/02/09... When someone attends a 'X' is placed in the
cell.

So if someone's last attendance was 1/04/09 the formula would return 13.

Any ideas?