Getting rid of +/- in date subtraction..
Certainly, as long as you do the subtraction the right way. Use:
=c6-c5
Regards,
Fred.
"Mark" wrote in message
...
My formula in cell c7 reads =c5-c6
If I put 01/01/2009 in c5
and 01/10/2009 in c6
I get -9 in c7
C6 will always be later than c5
Can I get rid of the (-) in c7? and have just a number?
Thanks in advance.
Mark
|