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.