# IF Formula with Dates

1. ## IF Formula with Dates

Basically I would like to say

Balance remaining X11 = IF B4 Date is 7 days more/after I11 then I would like for the subtraction P11 - W 11 to have incurred Labor hours , basically the task is done, we shouldnt need the labor hours in with "balance remaining"

Balance remaining X11 currently = \$585.68

I would like if the statement is true, the number should be \$194.60  If the statement is False, then we can just do P11 - W11 \$585.68

thanks  Register To Reply

2. ## Re: IF Formula with Dates

=\$B\$4---TRIM(SUBSTITUTE(RIGHT(I11,10),"-",""))  Register To Reply

3. ## Re: IF Formula with Dates

Bump for more help   Register To Reply

4. ## Re: IF Formula with Dates

you need to try explaining again, you seem to be saying either way if the statement is True or False P11=W11

maybe break it down to if True show what you want
if False show that  Register To Reply

5. ## Re: IF Formula with Dates

maybe this but i'm not making sense of what you want i fear

=IF(B4-(TRIM(RIGHT(I11,9))+0)>11,194.6,(P11-W11))  Register To Reply

6. ## Re: IF Formula with Dates Originally Posted by scottylad2 maybe this but i'm not making sense of what you want i fear

=IF(B4-(TRIM(RIGHT(I11,9))+0)>11,194.6,(P11-W11))
very close!!! I need an actually formula though, not just the \$194.60 number, so the formula should get me the \$194.60...if that makes sense.  Register To Reply

7. ## Re: IF Formula with Dates Originally Posted by scottylad2 you need to try explaining again, you seem to be saying either way if the statement is True or False P11=W11

maybe break it down to if True show what you want
if False show that
sorry for confusion,

If Statement is false, then P11 - W11 which in the excel formula, it should get me : \$585.68

IF The statement is True, that the B4 date is 7+ days more, then take (L11 * K11) + SUm(Q11:U11) so you get that number, we'll call it XX

then take P11 - XX which will

give me the formula for X11  Register To Reply

8. ## Re: IF Formula with Dates

use

=IF(\$B\$4-TRIM(SUBSTITUTE(RIGHT(I11,10),"-",""))>7,P11-(L11*K11+SUM(Q11:U11)),P11-W11)  Register To Reply