IF Formula with Dates

Please help (inexperience with dates) (see attachment)

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

Bump for more help

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.

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