Having two date return number but exclude negative numbers

**redjayhawk11** · 12-18-2013, 01:06 PM

I'm trying to figure out a formula to use that will exclude negative numbers. I have two dates. I'm trying to find the difference between the two dates assuming there is a date in the first column. At times there will be a situation where the date in A1 is before the date in A2 and it returns a negative number. I'd like to return a blank if there is a blank cell in column A and also return a blank if the return number is a negative.

Example:

A1 = 1/15/2013 B1= 1/10/2013 C1(formula) =IF(A1="","",(A1-B1) C1 will then reflect 5

A2 = (cell is blank) B2= 1/18/2013 C2 (formula) =IF(A2="","",(A2-B2) C2 will then reflect a blank cell

A3 = 1/5/2013 B3 = 1/15/2013 C3 (formula) =IF(A3="","",(A3-B3) C3 will then reflect -10

I'm trying to figure out a formula that would also allow C3 to reflect a blank cell since the formula returns a negative.

Thanks for your help

**etaf** · 12-18-2013, 01:18 PM

try

=IF(OR(A3="", A3-B3<0) ,"",(A3-B3))

**Kaper** · 12-18-2013, 01:19 PM

in C1:

Please Login or Register  to view this content.

and copy down

**easyexcelanswers** · 12-18-2013, 01:51 PM

Similar to previous but using the Datedif function

=IF(OR(A3=" ",B3=" ",A3<B3)," ",DATEDIF(A3,B3,"d"))

**redjayhawk11** · 12-19-2013, 03:15 PM

Awesome...each worked....really appreciate the help!!!

**etaf** · 12-31-2013, 06:34 AM

excellent , thanks for letting us know

if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved.

Having two date return number but exclude negative numbers

LinkBack

Thread Tools

Rate This Thread

Display

Having two date return number but exclude negative numbers

Re: Having two date return number but exclude negative numbers

Re: Having two date return number but exclude negative numbers

Re: Having two date return number but exclude negative numbers

Re: Having two date return number but exclude negative numbers

Re: Having two date return number but exclude negative numbers

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA to Sort Data and exclude the negative numbers with respect to time during averaging

[SOLVED] Determine whether number of positive numbers exceeds number of negative numbers

max number of a spreadsheet but exclude 3 numbers

Excel 2007 : Exclude negative number

Calculating The Largest Negative Number within a Range of Positive & Negative Numbers

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions