difference betwwen two dates in days

S

seven

I'm using Excel 2002 and i would like to calculate the difference between two
dates in days not in workdays. Unfortunately the help only give you how to
do it in workdays. Thank you for your help
 
A

Anne Troy

If there are dates in both A1 and B1, =A1-B1 will provide the number of days
between the two, just make sure you format the cell that contains the
formula as a number.
************
Anne Troy
www.OfficeArticles.com
 
B

Biff

Hi!

Just subtract!

A1 = 10/17/2005
B1 = 12/31/2005

=B1-A1

Format the cell as GENERAL

Biff
 
G

Gabriel

seven said:
I'm using Excel 2002 and i would like to calculate the difference between two
dates in days not in workdays. Unfortunately the help only give you how to
do it in workdays. Thank you for your help
Click to expand...
 
X

xlEnt

seven said:
I'm using Excel 2002 and i would like to calculate the difference
between two
dates in days not in workdays. Unfortunately the help only give you
how to
do it in workdays. Thank you for your help
Click to expand...
Your question is not clear, please elaborate
 
A

Arvi Laanemets

Hi

=A1-B1
, where A1 and B1 contain your dates, and format the result as number or
general
 
Top