If dates in Col A. Enter this in B2 and drag down

=IF(A2-A1>7,">7","")
Checks the cell above if > 7 it returns the text >7 otherwise leaves the cell blank

HTH

VBA Noob