If FALSE, leave cell blank - does not work

[flds]

Hello
When cell D5 is blank, below formula in L5 returns "False". I need to have cell L5 blank. Is there a way to tweak the formula.

formula is: =IF(D5>0,DATEDIF(D5-DAY(D5)+1,$E$3,"y"))

Cell D5 is passed date, Cell E3 is Today()

Your help would be appreciated.
Thanks

 

[Fluff]

How about

=IF(D5>0,DATEDIF(D5-DAY(D5)+1,$E$3,"y"),"")

 

[flds]

=IF(D5>0,DATEDIF(D5-DAY(D5)+1,$E$3,"y"),"")

 

[flds]

Thank Fluff, I did the same but did not separate it with a "," after ")", silly me.

I noticed when I have a current month it gives me "#NUM!" can this also be blank. All other pasted months and years work fine.
Can this same formula be modified?

Thanks for your help.

 

[flds]

Thank Fluff, I did the same but did not separate it with a "," after ")", silly me.

I noticed when I have a current month it gives me "#NUM!" can this also be blank. All other pasted months and years work fine.
Can this same formula be modified?

Thanks for your help.

Hello,
I am waiting for your response to the above issue I am facing. Will it be possible?

Thanks

 

[Buggirl3216]

Start your equation with =IFERROR( BLAH, " ") This will blank out any errors.

 

[flds]

Start your equation with =IFERROR( BLAH, " ") This will blank out any errors.

Hi Buggirl
Sorry, I did not follow what you meant. I would appreciate, If you send me the full formula.
I tried did not solve.

 

[flds]

Hi Buggirl
Sorry, I did not follow what you meant. I would appreciate, If you send me the full formula.
I tried did not solve.

Hi Buggirl,

I got it. =IFERROR(IF(D5>0,DATEDIF(D5-DAY(D5)+1,$E$3,"y")), " ")
Thanks

 

[flds]

Hi Buggirl,

Your formula IFERROR( BLAH, " ") worked for that particular cell which returned "#NUM!".
When I drag the formula down in column "L" it returns "FALSE" (see my #1 post).
Note: cells A to K are blank until I fill them, Column "L" cell is dragged down with =IF(D5>0,DATEDIF(D5-DAY(D5)+1,$E$3,"y"),"") formula and It works fine, only when entering the current month it returns "#NUM!".

Only if you can modify this formula it is fine. If not, I can live with the formula sent by Fluff (Moderator)

Appreciate your help.
Thanks

 

[cspengel]

Hi Buggirl,

Your formula IFERROR( BLAH, " ") worked for that particular cell which returned "#NUM!".
When I drag the formula down in column "L" it returns "FALSE" (see my #1 post).
Note: cells A to K are blank until I fill them, Column "L" cell is dragged down with =IF(D5>0,DATEDIF(D5-DAY(D5)+1,$E$3,"y"),"") formula and It works fine, only when entering the current month it returns "#NUM!".

Only if you can modify this formula it is fine. If not, I can live with the formula sent by Fluff (Moderator)

Appreciate your help.
Thanks

What about : =IFERROR(IF(D5>0,DATEDIF(D5-DAY(D5)+1,$E$3,"y"),""),"")