Leave values blank in calculated column

[ErikBI]

Hey guys,

This is probably something very simple but I can't figure it out. I have the following formula:

Time = 

IF(ISBLANK([startdate]);
    "";
    [enddate]-[startdate]
)

Basically, I'd like to calculate the difference between start and end date, but leave the cells in the calculated column blank if there is no end date. I can't do "" becuase I get the error saying that you can't mix integers and strings. I can do 0 instead but that makes my calculations after this more difficult.

Is there a way to say something like "null" to leave it blank?

Thanks in advance.

[ErikBI · Accepted solution]

I'm actually stupid. There is a function called BLANK() specificaly for this.