View Single Post
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default difference betwwen two dates in days

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


"seven" wrote in message
...
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