Thanks, it worked. I wasn't using the "--" what is the
purpose of the "--" in the formula?

-----Original Message-----
Using your data I get

E2: 167
E3: 227
E4: 227
E5: 171

Are your values numbers or text? (Try putting =ISTEXT(D2)
in another
cell).

Are your dates real XL dates? or are they text?

In article ,
"SAL" wrote:

All I'm getting are zeros.
.