In Column A I have values like this from row 5 to 35 for instance:

5

6

blank

7

8

blank

blank

2

I would like to count the number of non-blank value and return that in A1... so I use =COUNT(A5:A35)

but the next day, i have a new value in cell A36, so now i would like A1 to count A6:A36..always counting back 30.. from the last value in column A

How do i amend my excel A1 formula ?