count date between two date including start and end date

[john5599]

I need to count two period of date 22-12-2011 to 23-01-2012. including start and end date. Can anyone give a formula. 33 days are there.
=DATEDIF(E68,F68,"D") will give only 32 days. Pls. help me.

 

[VoG]

Try

=DATEDIF(E68,F68,"D")+1

 

[T. Valko]

I need to count two period of date 22-12-2011 to 23-01-2012. including start and end date. Can anyone give a formula. 33 days are there.
=DATEDIF(E68,F68,"D") will give only 32 days. Pls. help me.

One way...

A2 = 22-12-2011
B2 = 23-01-2012

Then:

=B2-A2+1

Format as General or Number

 

[john5599]

Is there anyother formula for calculate. Why should we add +1 with the command.

 

[VoG]

Those formulas give the difference between two dates. If you want to include the start and end dates then you have to add 1.

 

[john5599]

Can you explain what the formula says. Is +1 says to count the days including from date todate.

 

[VoG]

Yes.