One way:

=B1-A1+1

Format as General or Number.

In article ,
sunita_shaw
wrote:

Theres a problem I came across:
I would like to add the days between two cells

e.g:
A B
03/12/2006 03/20/2006

I want the total number of days that I took to complete my task i.e
9days
How do I get this 9days..what is the formula....

Someone Plzz help !!!!