EDATE (but with a formula instead of written date)

[Literae]

Bonjour,

So I am using a formula to calculate 6months on from a date. However the cell in question is also a formula. This works, until I want it to show blank when no date is there. I have found multiple options which should work, however as my cell is not "blank" exactly because there is a formula there, it doesnt work?

Formula:

=IF(A2<>"",EDATE(A2,6),"")

I have read that this arguement works as: If A2 is Blank, show Blank, but if it isnt, work out the EDate formula. Am I correct in thinking it doesnt work because I have a formula there? Currently I am getting: 01/07/1904 which is 6 months after 01/01/1904 which I believe is the default date for 0? I have tried it on a written date instead of my vlookup formula and it works so I think the issue is my A2 is not written and is a formula.

Any thoughts?

Solution: =IF((A2<>"")*(A2<>0),EDATE(A2,6),"")

[kvsrinivasamurthy]

Try this

=IFERROR(EDATE(1/(1/A2),6),"")

[Literae]

Try this

=IFERROR(EDATE(1/(1/A2),6),"")

Hi KV, tried that but says "too many arguments". I tried it with a written date and works fine, but not work but I put the vlookup cell as the reference (A2). Only seems to work if A2 is manually written.

Thanks anyway!

[Phuocam]

Try:

=IF((A2<>"")*(A2<>0),EDATE(A2,6),"")

[Literae]

Omg it works! Thank you!