I have a question and I’m really stacked I have a pivot table in excel in which I want to calculate the number of the projects that were initialized per each month this project when it is initialized it has the status created and it will have this status until it will be sold
for example the project1 was created at January and it was sold by august so it will have the status created the months from January until July and the the status will change to sold for all the months until end of year.my problem here is that I ant to calculate the number of initialized project per each month but I should not recalculated another time as I mentioned in my example here it should only be counted on January and ignore in the rest (it should be calculated the 1st month when the project was initialized only)how I can do this with excel I have proejct_id,status (sold or created) sold_date

I tried to do it with diffrent ways but I couldn’t