Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 989

Getting rid of +/- in date subtraction..

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date Subtraction	Newbie	Excel Worksheet Functions	3	January 17th 09 06:16 PM
date subtraction	[email protected]	Excel Worksheet Functions	6	December 9th 08 02:13 PM
Different results: Networkdays versus date subtraction	OxonLad	Excel Worksheet Functions	6	June 18th 08 03:38 PM
date and time in 2 cells to create subtraction in 3rd	MikeR-Oz	New Users to Excel	2	October 27th 07 10:35 AM
Date subtraction -How to not show negative when 2nd date not entered	Edward[_2_]	New Users to Excel	2	September 27th 07 03:03 PM

All times are GMT +1. The time now is 08:32 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us