Count number of users active each mont

[Wandem]

Hello,

I have a table with a list of users active in a system. There are the date that user was registered and the date that user was disabled. If the user was not disabled, than it`s active. I need a table summarizing number of user, per company, per month. How do I do this using VBA?

Thanks for any help.

I have data like this



ID user
User active
Register date
Date of exclusion
Company


10
n
01052020
10062020
Beer


11
y
01032020

Cat


12
y
01052020

Cat


13
y
01042020

Beer


14
n
01062020
01072020
Beer


Table generated in 07152020

I would like to have a table like this



Company
Month
Number of users


Beer
032020
0


Beer
042020
1


Beer
052020
2


Beer
062020
3


Beer
072020
2


Cat
032020
1


Cat
042020
1


Cat
052020
2


Cat
062020
2


Cat
072020
2