Count number of days between 2 dates

Count in days? Just put - between dates you want... E.g. A3-A2

No, just the number of times that appears, for exemple :

01-02-2009
15-02-2009
22-02-2009
25-02-2009
03-03-2009
11-03-2009

I only have 4 entries in february.....

If you put the min date in say cell D2

Then in E2 the formula:

=SUMPRODUCT(($A$1:$A$10>=D2)*1,($A$1:$A$10<=EOMONTH(D2,0))*1)

This give your answer. The range can be changed to suit.

EllBol

Thank a lot, it works just fine.....

Sorry to bother, but i´ve another question, the formula works fine, but i want to ad another condition, for example:

01-02-2009 A
15-02-2009 A
22-02-2009 A
25-02-2009 N
03-03-2009 N
11-03-2009 N

Count only february with A in the another column...

Thanks

That formula is not working for me,

http://spreadsheets.google.com/pub?k...MgjgwiJHA8SCJA

Maybe you can see what I want. I want to the number of times that appears "A" between 01-02-2009 and 28-02-2009, the result will be 3

Thanks

So what's the exact formula you are using? What result did you get with that formula?

The formula NBVC posted should work fine if you have the start date of the period in D1 and the end date in D2

That formula contains errors in my excell...

Your excel version may require ; in place of , so try like this

=Sumproduct(--(A1:A10>=D1);--(A1:A10<=D2);--(B1:B10="A"))

And if i use Dcount, it will work, if yes how can y use it??

Originally Posted by daddylonglegs

Your excel version may require ; in place of , so try like this

=Sumproduct(--(A1:A10>=D1);--(A1:A10<=D2);--(B1:B10="A"))

Y try like that, gives me 0, instead of 2