Stop a formula if a cell has a certain text

1. TODAY is volatile and if used a lot, could slow your file down. Rather, put TODAY() once in a cell somewhere (say, K1), then just reference it in your formula....=$K$1-$B2

2. If you need to not show anything if F contains a date...
=if(F2="",your-formula,"")
(I think Dark has it the wrong way round)

While you could just take the answer from the end of the post, I do hope that you take a moment understand the fundamentals of the if command because it is the most powerful command in my opinion one of the very core commands you should understand. Using this command you can accomplish almost anything in terms of excel (within reason of course)

So to help you understand how to make this work for you, you need to write out the goals you wish to achieve.

Write your request out in terms of IF statements then build the IF command using those statements.

So let's see if I get this right.

Based on your post.

This is what it sounds like you want.

1. If F HAS NO DATE then H to count days until F has a date
2. IF F has a date, show difference between b and F


Remember the pattern. =IF(THIS<=>THAT,DOIFTRUE,DOIFFALSE)
Does that sum it up?
So let's write the first IF statement

Please Login or Register  to view this content.

That means If F2 equals nothing, Subtract B2 from today's date otherwise do nothing. This fulfills your first requirement.

So what about your second requirement?
If F has a date, show the difference between B and F. Let's write that formula out.

Please Login or Register  to view this content.

That means IF F2 is anything other than nothing then F2-B2 otherwise do nothing.

Now we put them together and combine the sentences together.
If F2 EQUALS nothing then TODAYS DATE-F2 OTHERWISE DO IF F2 is ANYTHING OTHER THAN nothing then F2-B2 OTHERWISE DO nothing.

So replace the words in that sentence with the appropriate commands and you should have your formula. It would look like this.

Please Login or Register  to view this content.

You could also rephrase the sentence like this.
If F2 EQUALS nothing then TODAYS DATE-F2 OTHERWISE DO F2-B2.
You can write that out like this.

Please Login or Register  to view this content.

Easiest way to write complex nested statements is to write out the requirements into sentences and fill in the blanks (at least for me anyway)
I hope this help.

Does that solve your problem?