# 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

2. ## Re: IF Formula with Dates

the follwing may be helpfull

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

3. ## Re: IF Formula with Dates

Bump for more help

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

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))

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.

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

8. ## Re: IF Formula with Dates

use

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

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1