hi
I used =DATE (b10,c10,d10)-DATE(b9,c9,d9)
what should I have done?

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" <(E-Mail Removed)> wrote in message
news:444333D4-7B39-4482-B9ED-(E-Mail Removed)...
> hi
> I used =DATE (b10,c10,d10)-DATE(b9,c9,d9)
> what should I have done?

On Sat, 23 Jun 2007 17:00:00 -0700, leslie <(E-Mail Removed)>
wrote:

>hi
>I used =DATE (b10,c10,d10)-DATE(b9,c9,d9)
>what should I have done?

With so little information, it's hard to tell. Most likely, you should have
had entries in B910 that would be valid arguments for the DATE worksheet
function.


Post the contents of B910
What did you get??
What did you expect??
--ron