当前位置: 动力学知识库 > 问答 > 编程问答 >

excel - I have start and end date - how to count

问题描述:

I have start date and would like to count it like this...

StartDate End Date

2/4/2015 7/22/2015

7/22/2015

2/2/2015 8/1/2015

7/26/2015

10/8/2014 10/21/2014

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.

use =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.

UPDATE

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.

  1. select the cell A1
  2. tab "Data"
  3. from ribbon select the option to import the data from text.
  4. choose the text file download above. and say "Finish" then "Ok"
  5. then you will get the excel file ready.

Let me know still you can not get excel file working. Make it sure you have "Date" Formatting applied on first 2 columns

分享给朋友:
您可能感兴趣的文章:
随机阅读: