Forum Discussion
Leave values blank in calculated column
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.