How count date serial group from min to max as serial number

[SokhaKH]

Hi all dear Could you please help me to count date group serial from min to max as serial number frequency (Column B). Because i want to short item by date to other sheet. Sorry for my bad English (Please see in attach file for Example)Thanks in advanced

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

See if this is what you want.

21 12 04.xlsm
	A	B
1
2	4/12/2021	1
3	4/12/2021	2
4	4/12/2021	3
5	5/12/2021	5
6	4/12/2021	4
7	7/12/2021	7
8	5/12/2021	6
9	8/12/2021	8
Date Count

Cell Formulas
Range	Formula
B2:B9	B2	=RANK(A2,A$2:A$9,1)+COUNTIF(A$1:A1,A2)