increase count on tracking sheet based on date entry between dates in another sheet

hi

Back again, sorry.

I have some code shown below, which increases the count in a column based on input into the relevant cell

Private Sub Worksheet_Change(ByVal Target As Range) ' changes count when date changes

If Target.Column = 4 Then
Target.Offset(0, 1) = Target.Offset(0, 1) + 1
End If

End Sub

I would also like to increase the count in another worksheet based on date of entry falling between set dates and one other criterion.

in the attached workbook, if i change date in Sheet "safeguard" col D, i would like col E to increase by value of 1 and "tracking" rows 5-9 to increase by 1 based on date entered in "safeguard" col D and year group of student

any pointers greatly appreciated

cheers

demo.xlsm

Great, thanks very much, works beautifully