difference between the dates ex: 4/11/2008- 7/11/2008= 3 days
 

how to caliculate difference between the dates ex: 4/11/2008- 7/11/2008= 3
days

difference between the dates ex: 4/11/2008- 7/11/2008= 3 days
 

Hi,

In cell C1, enter B1-A1. Assuming 7/11/2008 is in cell B1 and the other
date is in cell A1. Format C1 as general

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"difference between the dates ex: 4/11/2" <difference between the dates ex:
wrote in message
...
how to caliculate difference between the dates ex: 4/11/2008- 7/11/2008=
3
days

difference between the dates ex: 4/11/2008- 7/11/2008= 3 days
 

=A2-A1+1

--
__________________________________
HTH

Bob

"difference between the dates ex: 4/11/2" <difference between the dates ex:
wrote in message
...
how to caliculate difference between the dates ex: 4/11/2008- 7/11/2008=
3
days

difference between the dates ex: 4/11/2008- 7/11/2008= 3 days
 

You may want to skip the +1, Bob?
--
David Biddulph

"Bob Phillips" wrote in message
...
=A2-A1+1

"difference between the dates ex: 4/11/2" <difference between the dates
ex: wrote in message
...
how to caliculate difference between the dates ex: 4/11/2008- 7/11/2008=
3
days

difference between the dates ex: 4/11/2008- 7/11/2008= 3 days
 

Hi

If the earlier date is in cell A1, and the later date in cell B1
=B1-A1
Format the cell with the formula as General.

If you want to enter dates in the formula, you need to enclose the dates
within double quotes
="07/11/2008"-"04/11/2008"
and give the later date first.

Rather than typing dates it is better to use the Date function
=DATE(2008,11,7)-DATE(2008,11,4)

--
Regards
Roger Govier

"difference between the dates ex: 4/11/2" <difference between the dates ex:
wrote in message
...
how to caliculate difference between the dates ex: 4/11/2008- 7/11/2008=
3
days