Hi,
Currently in Days open I have a formula of =-INT(A2-TODAY()). I want it to show "closed" if the status column states closed but keep the existing formula if it states pending. Can anyone advise how this is done?
Creation Date Days open Status
14/08/2013 35 CLOSED
05/05/2011 867 PENDING
Thanks
Bookmarks