Calculate active subscriptions

Hello. i need to calculate how many active subscritions i had on each day (only "ACTIVE" on D:D cells)
I am attaching a database with the start and end of each sibscritions

attached sheet has macro on green button

Thank you very much!! IŽll test it right now.
This can only be done with macro?

Post the file

Originally Posted by JohnTopley

Post the file

File attached. Thank you

Yout latest file is nit the same format as your original posted file so the VBA will fail,

change your code to that below
you have moved the columns over by two compared to your original.
torachan

Please Login or Register  to view this content.

Thank you very much for your time and effort, but the collums will grow every day, also the last day will grow by one every day, so i need i code that can handle that

You need to more clearly explain how the columns expand AND what dates constitute an Active subscription i.e are we testing Dates in Column A against a Start/Finish date? If so, which ones?

Ok, sorry if i did not made myself clear.
Every day i download a csv file with the subscriptions data.
Then i manually add the last day in the date list ( i did not find a way to make this list dynamic, wich the last date is the last date with data in the csv file) and then update the total subscriptions.
Please let me know if there is something i did not made clear.

And again, thank you very much for your time for helping me.

If someone is interested, i got a better solution, without VBA from other forum:

=CONT.SES(BD_subscriptions_Stripe[Status];"<>canceled";BD_subscriptions_Stripe[Start (UTC)];"<="&A2;BD_subscriptions_Stripe[Current Period End (UTC)];">="&A2)