Function DatePartCheck(dateChecked as Date) As Integer
Dim yearStart as Date
Dim yearCheck, i as Integer
i = DatePart("ww", dateChecked, vbSunday, vbFirstJan1)
If i = 53 Then
yearCheck = Year(dateChecked) +1
yearStart = Dlookup("startDate","lookupTable", "inYear = " & yearCheck)
If...