Help with date

[Anonymous]

Hi,

im trying to calculate the number of days an item is opened. (Attached below)

If Column A is Blank, Column B should show the number of days an item is opened for

However if column A has a date, then colmn B should be blank or have "0"

Another issue im having is the huge negative number on column B

Thank you

[amitchandak · Accepted solution]

@Anonymous , Try a new column like

if(isblank([A]), datediff([date creation],today(), day), 0)

[Anonymous]

Worked. Thank you