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

 

[Eric W]

Re: dateif

How about:

=IF(A3="","",IF(A3<=$A$1,"Due",A3-$A$1))

 

[Vtookup]

Re: dateif

Hi Eric.
your formula worked, but as the date progress it starting counting again.
what if the counting will have "due" in front of it or just stop at "due"?
Thanks

 

[Joe4]

Re: dateif

I am not quite clear what you are saying/asking.
Could you provide us with a few different examples representing different scenarios, and let us know the result you would like to see for each scenario?

 

[Vtookup]

Re: dateif

Hi Joe4.
Sorry not to mention that i have a list of Due dates in column A, but some cells are empty (exceptions)
column B will be the countdown (formula).

the formula in post#1 count days if A3 is greater than A1, then "Due" if A3 is met.
i like to extend the formula to deal with empty space in column A
it should be space instead of "Due".
Thanks.

 

[Tetra201]

Re: dateif

Maybe

=IF(A3="","",IFERROR(DATEDIF($A$1+1,A3+1,"d"),"Due"))

 

[Vtookup]

Re: dateif

Hi Guys.
this is embarrassing, no wonder it keep counting, the computation of $A$1+1,A3+1 is the reverse.
it should be the other way around.
Eric, you got the right solution, i just change "lesser" to "greater than"
Tetra201, your solution is also correct.
sorry to have overlooked.
Thank You for your helps.

 

[Vtookup]

Re: dateif

now i'm getting confused!
It's the right order. not reverse.
Sorry again.

 

[Joe4]

Re: dateif

I go back to what I asked for earlier:

Could you provide us with a few different examples representing different scenarios, and let us know the result you would like to see for each scenario?

I am looking for actual data examples.
Sometimes a picture says a thousand words...

Note that there are tools you can use to post screen images. They are listed in Section B of this link here: Guidelines for Forum Use.
Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.

 

[Vtookup]

Hi Joe4.
this is really simple. the confusion lies within me. sorry about that. Eric and Tetra201 got it right.
-A >>>>>>>>>>>>>.B
8/19/2017
Due Date >>>>>>Days Left
8/15/2017 >>>>>>>Due
<space><space>(space) >>>>>>>(space)
10/19/2017 >>>>>>>61
I have tried this first, i can't get it right, always got formula error.
my mistakes lies in the parenthesis. Almost got it right.
anyway, thanks to this forum, someone is always here to help.
keep up the good work.
Thanks Joe4</space></space>