sum product

[chazzerman01]

I have another problem, the formula I have used is =SUMPRODUCT(--(RIGHT(I6,5)>="66667")) and I'm using it so that when any of the numbers in the I column reach "a number".66667 then it adds a day to the date as shown in orange. the problem im having is that in one of the boxes (i11) theres a number which is 0.41667 and it includes it in the equation and marks it as 1(true) even though it should stay 0 (false)
hope you can help and I hop eth photo is clear enough

 

[Peter_SSs]

The value you are referring to probably has more decimal places than are showing in the cell and the formula is looking at the right of the number, not the right of the cell.
You might need to round the numbers in the column to 5 decimal places.