Thread
:
Getting rid of +/- in date subtraction..
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_]
external usenet poster
Posts: 8,651
Getting rid of +/- in date subtraction..
Or, as the OP has said that C6 will always be later than C5, just use =C6-C5
--
David Biddulph
"DILipandey" wrote in message
...
Hi Mar,
you can use =abs(c5-c6)
thanks
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
New Delhi, India
"Mark" wrote:
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
Reply With Quote
David Biddulph[_2_]
View Public Profile
Find all posts by David Biddulph[_2_]