Ok - thanks for the try guys but here's what I need:

Q7 = 8/15/05 (date format)
M7 = 7/2/05 (date format)

I would like to subtract M7 from Q7 and get a date, not a number - for
example -

Q7-M7 - OH Boy, I just realized my mistake...I guess sometimes it helps
to talk it out like this.

However, my second question is this:

Q7=6/7/05
M7=1/17/05


so what I have in P7 is (Q7-M7) which gives a number of days, and that
is what I want.

(P7 = 141)

But in R7, I have (p7+30) this also gives me a number of days. What I
want here is a date.

Right now I have a number - 141+30=171


Ahhh - right now I see my problem. I can't add two dates together like
that it's impossible.

Thanks guys for the great advice :)

I figured it out!!!!!!!
Heather