The formula should work as written. What do you get as a result? What are
the values you are working with? Be sure to format the formula cell for
General, not Date.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"leslie" wrote in message
...
hi
I used =DATE (b10,c10,d10)-DATE(b9,c9,d9)
what should I have done?