Employee Headcount at a certain point of time.

B

bet11878

New Member
Joined
Oct 15, 2020
Messages
1
Office Version
  1. 365
Platform
  1. MacOS
Hi there!

I need to manually calculate headcount at certain points of time. I have the employees start and end dates and a few other good pieces of information. Is there an easy way to do this? Like I want to say "what is the headcount at Q3 fo 2019, and again Q3 2020"?

EmployeeStart DateEnd DateStatus
Employee 1
5/8/17​
4/24/20​
Inactive Employee
Employee 2
6/16/14​
9/21/18​
Inactive Employee
Employee 3
2/19/19​
10/31/19​
Inactive Employee
Employee 4
12/14/16​
12/13/19​
Inactive Employee
Employee 5
6/25/18​
3/31/20​
Inactive Employee
Employee 6
10/17/17​
1/11/19​
Inactive Employee
Employee 7
2/1/16​
2/6/17​
Inactive Employee
Employee 8
1/1/14​
2/15/19​
Inactive Employee
Employee 9
7/5/17​
2/15/20​
Inactive Employee
Employee 10
2/27/17​
4/6/18​
Inactive Employee
Employee 11
9/2/13​
11/7/19​
Inactive Employee
Employee 12
8/28/17​
4/12/19​
Inactive Employee
Employee 13
5/31/16​
7/10/17​
Inactive Employee
Employee 14
8/14/17​
5/16/18​
Inactive Employee
Employee 15
3/5/18​
8/21/20​
Inactive Employee
Employee 16
6/18/18​
5/1/20​
Inactive Employee
Employee 17
9/14/15​
5/12/17​
Inactive Employee
Employee 18
6/5/17​
7/2/20​
Inactive Employee
Employee 19
6/3/13​
7/21/17​
Inactive Employee
Employee 20
4/15/19​
2/15/20​
Inactive Employee
Employee 21
2/26/14​
12/20/18​
Inactive Employee
Employee 22
11/3/14​
5/3/18​
Inactive Employee
Employee 23
12/3/18​
12/13/19​
Inactive Employee
Employee 24
5/31/16​
9/6/19​
Inactive Employee
Employee 25
9/21/15​
8/3/18​
Inactive Employee
Employee 26
4/22/15​
10/11/18​
Inactive Employee
Employee 27
3/6/17​
3/2/18​
Inactive Employee
Employee 28
1/1/14​
4/14/17​
Inactive Employee
Employee 29
1/7/19​
4/10/20​
Inactive Employee
Employee 30
1/14/16​
1/25/19​
Inactive Employee
Employee 31
9/11/17​
9/26/18​
Inactive Employee
Employee 32
4/16/18​
6/19/20​
Inactive Employee
Employee 33
3/5/18​
4/10/20​
Inactive Employee
Employee 34
7/1/16​
8/31/18​
Inactive Employee
Employee 35
4/16/19​
1/27/20​
Inactive Employee
Employee 36
3/27/17​
4/26/19​
Inactive Employee
Employee 37
6/23/14​
12/2/16​
Inactive Employee
Employee 38
10/15/18​
4/15/20​
Inactive Employee
Employee 39
9/6/16​
7/19/19​
Inactive Employee
Employee 40
11/17/14​
7/20/18​
Inactive Employee
Employee 41
6/19/15​
12/20/19​
Inactive Employee
Employee 42
11/28/16​
3/2/18​
Inactive Employee
Employee 43
4/30/18​
3/13/20​
Inactive Employee
Employee 44
1/7/19​
2/19/20​
Inactive Employee
Employee 45
10/30/17​
4/17/20​
Inactive Employee
Employee 46
7/1/15​
1/3/20​
Inactive Employee
Employee 47
3/7/16​
11/14/19​
Inactive Employee
Employee 48
8/20/18​
3/20/20​
Inactive Employee
Employee 49
9/11/17​
9/13/19​
Inactive Employee
Employee 50
9/8/15​
8/2/19​
Inactive Employee
Employee 51
2/8/16​
7/31/20​
Inactive Employee
Employee 52
6/3/19​
10/25/19​
Inactive Employee
Employee 53
2/21/17​
7/2/19​
Inactive Employee
Employee 54
7/5/16​
12/20/18​
Inactive Employee
Employee 55
10/3/16​
7/29/20​
Inactive Employee
Employee 56
11/12/18​
11/29/19​
Inactive Employee
Employee 57
10/2/17​
10/10/18​
Inactive Employee
Employee 58
8/1/17​
8/9/19​
Inactive Employee
Employee 59
11/14/18​
12/13/18​
Inactive Employee
Employee 60
3/18/15​
6/24/16​
Inactive Employee
Employee 61
8/24/15​
11/8/19​
Inactive Employee
Employee 62
6/30/14​
9/23/16​
Inactive Employee
Employee 63
1/3/18​
8/17/18​
Inactive Employee
Employee 64
3/3/14​
8/4/17​
Inactive Employee
Employee 65
9/14/15​
2/27/18​
Inactive Employee
Employee 66
2/2/15​
3/30/18​
Inactive Employee
Employee 67
4/8/19​
4/10/20​
Inactive Employee
Employee 68
4/16/19​
6/30/20​
Inactive Employee
Employee 69
6/22/17​
3/27/20​
Inactive Employee
Employee 70
6/4/18​
12/31/19​
Inactive Employee
Employee 71
3/3/14​
3/3/18​
Inactive Employee
Employee 72
6/9/14​
7/6/18​
Inactive Employee
Employee 73
2/1/17​
7/31/17​
Inactive Employee
Employee 74
9/1/17​
4/17/20​
Inactive Employee
Employee 75
4/4/16​
4/6/18​
Inactive Employee
Employee 76
12/2/19​
4/10/20​
Inactive Employee
Employee 77
7/9/18​
8/2/19​
Inactive Employee
Employee 78
6/22/15​
8/15/16​
Inactive Employee
Employee 79
8/3/20​
Active Employee
Employee 80
8/24/15​
Active Employee
Employee 81
1/22/19​
Active Employee
Employee 82
1/28/19​
Active Employee
Employee 83
2/3/14​
Active Employee
Employee 84
5/12/14​
8/28/14​
Inactive Employee
Employee 85
9/18/17​
Active Employee
Employee 86
6/2/14​
8/15/14​
Inactive Employee
Employee 87
8/10/15​
6/17/16​
Inactive Employee
Employee 88
4/1/15​
9/16/16​
Inactive Employee
Employee 89
1/4/16​
7/15/16​
Inactive Employee
Employee 90
6/3/13​
5/29/20​
Inactive Employee
Employee 91
9/14/15​
7/20/18​
Inactive Employee
Employee 92
9/21/20​
Active Employee
Employee 93
1/14/19​
Active Employee
Employee 94
12/3/18​
Active Employee
Employee 95
2/2/18​
Active Employee
Employee 96
7/24/17​
Active Employee
Employee 97
6/18/18​
Active Employee
Employee 98
11/4/19​
Active Employee
Employee 99
4/27/15​
Active Employee
Employee 100
3/15/17​
Active Employee
Employee 101
6/1/20​
Active Employee
Employee 102
3/6/14​
10/21/15​
Inactive Employee
Employee 103
5/6/19​
Active Employee
Employee 104
2/1/16​
Active Employee
Employee 105
9/6/18​
Active Employee
Employee 106
8/20/18​
Active Employee
Employee 107
2/20/17​
Active Employee
Employee 108
8/25/14​
Active Employee
Employee 109
10/14/13​
Active Employee
Employee 110
10/29/18​
Active Employee
Employee 111
6/10/19​
Active Employee
Employee 112
2/20/18​
Active Employee
Employee 113
3/2/20​
Active Employee
Employee 114
10/16/17​
Active Employee
Employee 115
6/8/15​
Active Employee
Employee 116
10/7/19​
Active Employee
Employee 117
12/3/18​
Active Employee
Employee 118
8/5/19​
Active Employee
Employee 119
1/9/17​
Active Employee
Employee 120
9/25/17​
Active Employee
Employee 121
4/30/18​
Active Employee
Employee 122
4/11/16​
Active Employee
Employee 123
3/18/19​
Active Employee
Employee 124
6/15/20​
Active Employee
Employee 125
9/14/15​
Active Employee
Employee 126
8/5/19​
Active Employee
Employee 127
4/4/16​
Active Employee
Employee 128
11/4/19​
Active Employee
Employee 129
1/9/17​
Active Employee
Employee 130
9/4/18​
Active Employee
Employee 131
7/1/13​
Active Employee
Employee 132
10/17/16​
Active Employee
Employee 133
5/27/19​
Active Employee
Employee 134
10/30/17​
Active Employee
Employee 135
12/2/19​
Active Employee
Employee 136
10/13/14​
4/17/15​
Inactive Employee
Employee 137
7/6/20​
Active Employee
Employee 138
12/8/14​
4/15/15​
Inactive Employee
Employee 139
1/22/19​
Active Employee
Employee 140
1/10/12​
10/9/20​
Inactive Employee
Employee 141
2/12/18​
Active Employee
Employee 142
1/7/19​
Active Employee
Employee 143
9/8/14​
1/30/15​
Inactive Employee
Employee 144
5/20/19​
Active Employee
Employee 145
6/17/19​
Active Employee
Employee 146
8/24/17​
Active Employee
Employee 147
12/2/19​
Active Employee
Employee 148
1/8/18​
Active Employee
Employee 149
4/6/20​
Active Employee
Employee 150
8/5/19​
Active Employee
Employee 151
7/22/19​
Active Employee
Employee 152
7/2/18​
Active Employee
Employee 153
6/3/19​
Active Employee
Employee 154
7/24/19​
Active Employee
Employee 155
6/5/17​
Active Employee
Employee 156
1/6/20​
Active Employee
Employee 157
9/30/19​
Active Employee
Employee 158
7/6/20​
Active Employee
Employee 159
5/7/18​
Active Employee
Employee 160
10/28/13​
1/30/15​
Inactive Employee
Employee 161
9/5/17​
Active Employee
Employee 162
11/12/12​
Active Employee
Employee 163
5/21/18​
Active Employee
Employee 164
2/20/17​
Active Employee
Employee 165
6/18/18​
Active Employee
Employee 166
6/4/18​
Active Employee
Employee 167
11/26/18​
Active Employee
Employee 168
3/1/15​
Active Employee
Employee 169
3/4/19​
Active Employee
Employee 170
7/13/15​
Active Employee
Employee 171
6/17/19​
Active Employee
Employee 172
8/31/15​
Active Employee
Employee 173
8/5/19​
Active Employee
Employee 174
4/10/17​
Active Employee
Employee 175
3/4/19​
Active Employee
Employee 176
8/9/17​
Active Employee
Employee 177
11/7/16​
Active Employee
Employee 178
9/4/18​
Active Employee
Employee 179
7/8/19​
Active Employee
Employee 180
10/13/15​
Active Employee
Employee 181
12/11/17​
Active Employee
Employee 182
2/23/15​
Active Employee
Employee 183
6/10/13​
Active Employee
Employee 184
9/1/14​
10/10/14​
Inactive Employee
Employee 185
1/18/17​
Active Employee
Employee 186
1/8/18​
Active Employee
Employee 187
5/20/19​
Active Employee
Employee 188
10/7/19​
Active Employee
Employee 189
5/24/17​
Active Employee
Employee 190
11/26/18​
Active Employee
Employee 191
5/20/19​
Active Employee
Employee 192
12/3/18​
Active Employee
Employee 193
4/9/18​
Active Employee
Employee 194
2/5/18​
Active Employee
Employee 195
7/17/17​
Active Employee
Employee 196
1/21/20​
Active Employee
Employee 197
7/6/15​
Active Employee
Employee 198
7/8/19​
Active Employee
Employee 199
2/20/17​
Active Employee
Employee 200
9/8/20​
Active Employee
Employee 201
2/18/20​
Active Employee
Employee 202
2/26/18​
Active Employee
Employee 203
8/1/17​
Active Employee
Employee 204
12/6/11​
Active Employee
Employee 205
7/22/19​
Active Employee
Employee 206
10/21/19​
Active Employee
Employee 207
5/21/18​
Active Employee
Employee 208
7/17/17​
Active Employee
Employee 209
6/4/18​
Active Employee
Employee 210
8/31/15​
Active Employee
Employee 211
9/18/17​
Active Employee
Employee 212
9/22/14​
2/11/15​
Inactive Employee
Employee 213
8/5/19​
Active Employee
Employee 214
6/10/13​
Active Employee
Employee 215
1/21/20​
Active Employee
Employee 216
1/13/20​
Active Employee
Employee 217
9/2/19​
Active Employee
Employee 218
4/6/20​
Active Employee
Employee 219
12/17/18​
Active Employee
Employee 220
1/1/14​
Active Employee
Employee 221
3/16/20​
Active Employee
Employee 222
1/21/20​
Active Employee
Employee 223
10/24/18​
Active Employee
Employee 224
11/5/18​
Active Employee
Employee 225
1/1/14​
10/9/20​
Inactive Employee
Employee 226
8/17/17​
Active Employee
Employee 227
8/5/19​
Active Employee
Employee 228
1/6/20​
Active Employee
Employee 229
11/14/16​
Active Employee
Employee 230
9/4/18​
Active Employee
Employee 231
6/11/13​
Active Employee
Employee 232
3/16/20​
Active Employee
Employee 233
12/17/18​
Active Employee
Employee 234
10/16/18​
Active Employee
Employee 235
1/5/15​
1/30/15​
Inactive Employee
Employee 236
9/16/19​
Active Employee
Employee 237
5/13/19​
Active Employee
Employee 238
5/16/16​
Active Employee
Employee 239
8/21/17​
Active Employee
Employee 240
6/1/17​
Active Employee
Employee 241
4/22/19​
Active Employee
Employee 242
5/6/19​
Active Employee
Employee 243
9/23/19​
Active Employee
Employee 244
8/19/19​
Active Employee
Employee 245
7/23/18​
Active Employee
Employee 246
6/18/18​
Active Employee
Employee 247
8/18/14​
Active Employee
Employee 248
5/5/14​
Active Employee
Employee 249
12/6/19​
Active Employee
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
Sort by date Sort by votes
How about
+Fluff v2.xlsm
ABCDEFG
1EmployeeStart DateEnd DateStatus
2Employee 20406/12/2011Active Employee01/01/201916
3Employee 14010/01/201209/10/2020Inactive Employee
4Employee 16212/11/2012Active Employee
5Employee 1903/06/201321/07/2017Inactive Employee
6Employee 9003/06/201329/05/2020Inactive Employee
7Employee 18310/06/2013Active Employee
8Employee 21410/06/2013Active Employee
9Employee 23111/06/2013Active Employee
10Employee 13101/07/2013Active Employee
11Employee 1102/09/201307/11/2019Inactive Employee
12Employee 10914/10/2013Active Employee
13Employee 16028/10/201330/01/2015Inactive Employee
14Employee 801/01/201415/02/2019Inactive Employee
15Employee 2801/01/201414/04/2017Inactive Employee
16Employee 22001/01/2014Active Employee
17Employee 22501/01/201409/10/2020Inactive Employee
18Employee 8303/02/2014Active Employee
19Employee 2126/02/201420/12/2018Inactive Employee
20Employee 6403/03/201404/08/2017Inactive Employee
21Employee 7103/03/201403/03/2018Inactive Employee
22Employee 10206/03/201421/10/2015Inactive Employee
23Employee 24805/05/2014Active Employee
24Employee 8412/05/201428/08/2014Inactive Employee
25Employee 8602/06/201415/08/2014Inactive Employee
26Employee 7209/06/201406/07/2018Inactive Employee
27Employee 216/06/201421/09/2018Inactive Employee
28Employee 3723/06/201402/12/2016Inactive Employee
29Employee 6230/06/201423/09/2016Inactive Employee
30Employee 24718/08/2014Active Employee
Completed
Cell Formulas
RangeFormula
G2G2=COUNT(FILTER(ROW(B2:B30),(B2:B30<=F2)*((C2:C30>=F2)+(C2:C30=0))))
 
Upvote 0
You must log in or register to reply here.

Similar threads

Knockoutpie
  • Solved
Transpose cells in a column if adjacent criteria matches
Replies
5
Views
98
Fluff
Fluff
McM_
  • Solved
Amount calculation in progress
Replies
4
Views
140
dreid1011
dreid1011
R
  • Question
Formula for % of employee trained based on certain criteria
Replies
5
Views
235
Armstrong_N14
A
I
  • Question
Tracking vacation requests
Replies
9
Views
439
KRice
K
B
  • Question
VBA to show and change list of names depending on selection
Replies
7
Views
462
mumps
mumps

Forum statistics

Threads
1,214,915
Messages
6,122,212
Members
449,074
Latest member
cancansova

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top