calculating # of days
 

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

calculating # of days
 

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?

calculating # of days
 

On Sat, 23 Jun 2007 17:00:00 -0700, leslie
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 B9:D10 that would be valid arguments for the DATE worksheet
function.


Post the contents of B9:D10
What did you get??
What did you expect??
--ron