View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default 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