Thread
:
Getting rid of +/- in date subtraction..
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
DILipandey
external usenet poster
Posts: 70
Getting rid of +/- in date subtraction..
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
DILipandey
View Public Profile
Find all posts by DILipandey