# Count every day

#### GSB22

##### New Member
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!

### Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

#### Gerald Higgins

##### Well-known Member
Code:
``=(a2-a1)+1``

#### lenze

##### Legend
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
Code:
``=DATEDIF(A2,A1)+1``

lenze

#### GSB22

##### New Member
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!

Last edited:

Replies
4
Views
97
Replies
6
Views
102
Replies
5
Views
206
Replies
2
Views
117
Replies
7
Views
69

1,191,707
Messages
5,988,192
Members
440,138
Latest member
yanaa

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back