Count every day

[GSB22]

Hello,
There's got to be an easy formula for counting every day, starting on one date and ending another. For instance, if I want to count every day from 1/1/2009 to 31/1/2009, I'm expecting an answer of 31. But when you do a simple subtraction or Datedif() formula, I get 30.

So simply what I'm looking for is:
A1: 1/1/2009
A2: 31/1/2009
A3: 31 (not 30)

Any help will be appreciated.

Thanks!

 

[Gerald Higgins]

How about

=(a2-a1)+1

 

[lenze]

Hi and welcome to the board!!

31-1 does equal 30. That is the correct answer If you want 31, you need to add 1 to your formula

=DATEDIF(A2,A1)+1

lenze

 

[GSB22]

Ha! Because that would be too easy. I just assumed Excel would have a formula. Maybe they should add a Daysactual formula. But you are correct. That will work too.

Thanks!