shots between failure

Hi all,   I have been trying for weeks to figure this one out. What I have is a calculated column containing the values for "gross shots". I am trying to find the difference from one date to the ne...