datedif

[Vtookup]

Hi all.
i come across this formula online =IFERROR(DATEDIF($A$1+1,A3+1,"d"),"Due") which is effective
A1=today() and A3=due date
but if A3 is empty it still reflect Due
how do i make this formula to display space if A3 is empty?
Thanks in advance for any help

 

[Joe4]

So, what is your expected result? Which number are you trying to calculate in your example?
You can get to 61 simply by subtracting A1 from A3, i.e.

=A3-A1

But I think you provided an oversimplified example. I want to see an example of one that is not working out the way you want, along with showing us what you want the answer to be.

 

[Vtookup]

Hi again Joe4

 

[Joe4]

OK, so what's the problem then?
Like I said, from the example you posted, it would just be:

=A3-A1

Is there still some outstanding question, or are you all set?

 

[Vtookup]

Hi.
there's no more problem joe4. this is solved.
post#1, i'm just asking how to resolved with blank space.
sorry for the confusion.

 

[Joe4]

OK. It looked like that you might still have a question, but if you say you don't, then we'll just leave well enough alone.