auto increment number

Question

hello..

 

how do i make code to auto increment number when date has increase?

eg:

date	number
3/7/2020	1
10/7/2020	2
17/7/2020	3
24/7/2020	4

 

Please help. i am urgently need help