I have start date and would like to count it like this...
StartDate End Date
I would like to count membership so to show me for each month how many active members I had?
How would I do this in excel?
you can do it.
=IF(1>=MONTH($A3),IF(1>MONTH(IF($B3<>"",$B3,NOW())),0,IF($D3<>0,1,0)),0) + $E3 to calculate the months in year range. its for Jan. you can modify for feb to dec.
And total all values to find the sum. check the image. If you want this. I will give u the link to download this spread sheet.
Download the excel file from here. DownloadLink
UPDATE As if above excel you can not open properly give it a try. download the excel formula that i applied on excel file. Formula
open new excel.
Let me know still you can not get excel file working. Make it sure you have "Date" Formatting applied on first 2 columns