Calculate days between dates
 

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 !!!!


--
sunita_shaw
------------------------------------------------------------------------
sunita_shaw's Profile: http://www.excelforum.com/member.php...o&userid=32227
View this thread: http://www.excelforum.com/showthread...hreadid=519764

Calculate days between dates
 

In C1,

=B1-A1+1

Format the cell of your result as General or Number to 0 decimal
places.

HTH,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=519764

Calculate days between dates
 

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 !!!!

Calculate days between dates
 

Hi! Steve , I tried but my dates get formated into plain numbers and
when I try doing it some other sheet too I get the difference in the
form of dates...


--
sunita_shaw
------------------------------------------------------------------------
sunita_shaw's Profile: http://www.excelforum.com/member.php...o&userid=32227
View this thread: http://www.excelforum.com/showthread...hreadid=519764

Calculate days between dates
 

Sunita,

Keep the cells where your dates are formatted as dates. Only change
the format of the cell that you input the formula into to a number to
return only a number.

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=519764