Calculating years with 'if empty' column

[tomdegezelle]

Hello,

I have two columns with a date (column F and G)
I want to calculate the amount of years between the two dates in column H.
But what if column G is empty ?

This is my formula, but it troughs an error, (too less arguments).
I don't know what is wrong.
Can someone help me please.

Formula_Dates.jpg


=ALS(ISLEEG(G5);(DATUMVERSCHIL(F5;VANDAAG());"y");(DATUMVERSCHIL(G5-F5);"y"))

[AliGW]

Welcome to the forum.

I think you need another bracket after "y"):

...;"y"));...

[tomdegezelle]

Thank you AliGW.
I tried, but I get the same message.

[Vraag en antwoord]

It is better to post the formula in English on an English-language forum. It is even better to place a sample file
In Dutch

Please Login or Register  to view this content.

In English

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[tomdegezelle]

Thank you very much.
The formula works fine.

I wll keep it in mind to post in English.

Thanks,
Tom