Forum Discussion
Help with date
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
Anonymous , Try a new column like
if(isblank([A]), datediff([date creation],today(), day), 0)
2 Replies
Anonymous , Try a new column like
if(isblank([A]), datediff([date creation],today(), day), 0)