Datediff if one column has blanks

[Anonymous]

I would like to calculate years between two date columns, one is "StartDate" and the other "EndDate".

EndDate has blanks and I would like to use a specific date as blank substitute: "2016-12-31"

I know it is something like:  IF( ISBLANK(  in combination with DATEDIFF but I can't figure out how to write it.

Thank you!

[Greg_Deckler · Accepted solution]

@Anonymous Try:

Column = IF([EndDate] = BLANK(),DATEDFF([StartDate],DATE(2016,12,31)),DATEDIFF([StartDate],[EndDate]))

[Anonymous]

Thank you very much! It worked perfect with interval argument as YEAR.