Assuming real dates in A1 & B1,
where B1's date (enddate) is later than A1's startdate
then in C1: =IF(COUNT(A1:B1)=2,B1-A1,"")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,000 Files:354 Subscribers:53
xdemechanik
---
" wrote:
I am trying to get : how many days between two columns: A contains dates,
column B contains also dates to get results on column C for example :
A B C
04.05.2008 06.07.2008 ? (how many days)

many thanks,
M.Barada
UAE