How to count number of employees from joing date

[Hossam Ahmed]

Dear gents,

Can you please help me to find an equation to count the number of employees from joining date.

For example i have 2 columns first one includes names of employees and second column contain the joining date, i need to add third column to count the number of employees when i reach to specific date, so the equation should count the new hired employee in addition to the previous, so if the last cell count that we have 5 employees so next cell should count 6 1 new + 5 previous).

Here is an example:

Columns will be

Name.joining date. count

X1 . 1/1/2021 . 1

X2 . 2/1/2021 . 2 (1 previous +1new)

X3 . 3/1/2021 . 3 (2 previous + 1 new)


Thanks alot

 

[jtakw]

You asked for a COUNT, so that's all the formula is doing.
One way I can think of is using RANK, but if you have people who joined on the same day, it'll throw the numbers off:

Book3.xlsx
	A	B	C
1	Name	Join Date
2	X1	1/1/2021	1
3	X2	1/2/2021	2
4	X3	1/3/2021	3
5	X4	1/4/2021	4
6	X5	1/5/2021	5
7	X6	1/6/2021	6
8	X7	1/7/2021	7
9	X8	1/8/2021	8
10	X9	1/9/2021	9
11	X10	1/10/2021	10
12	X11
13	x12	1/1/2022	11
14
15	X13	1/3/2022	12
16
17
Sheet1050

Cell Formulas
Range	Formula
C2:C17	C2	=IFERROR(RANK(B2,B$2:B$15,2),"")