Public m&
Sub lqxs()
Dim Arr, i&, Brr(1 To 27, 1 To 23), rq, nl
Sheet1.Activate
[c5:z32].ClearContents
Myr = Sheet2.[a65536].End(xlUp).Row
Arr = Sheet2.Range("a7:t" & Myr)
For i = 1 To UBound(Arr)
rq = DateSerial(Left(Arr(i, 7), 4), Mid(Arr(i, 7), 5, 2), Right(Arr(i, 7), 2))
nl = DateDiff("yyyy", rq, Now)
Call jd(Arr(i, 13))
Brr(1, nl + 1) = Brr(1, nl + 1) + 1
Brr(m, nl + 1) = Brr(m, nl + 1) + 1
Next
[d5].Resize(27, 23) = Brr
[c5].Formula = "=sum(rc[1]:rc[23])"
[c5].AutoFill [c5].Resize(27, 1)
[d6].Formula = "=sum(r[1]c:r[4]c)"
[d6].AutoFill [d6].Resize(1, 23)
End Sub