calculating # of days

[leslie]

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

 

[Chip Pearson]

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)

 

[Ron Rosenfeld]

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