Excuse me, but why can't you simply use the formula: =SUM(B1-a1)
as long as columns A & B are formatted as dates, and C as a number?

It always works for me.

k

"M Kan" wrote:

=DATE(RIGHT(C21,4),LEFT(C21,2),MID(C21,4,2))-DATE(RIGHT(B21,4),LEFT(B21,2),MID(B21,4,2))

Where C21 is your end date
B21 is your start date and I assumed your date format was month.day.year,
which may not be a good assumption.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


" wrote:

Hi,
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