If column N "Resolution Date" is blank, result is blank
If Column N is not blank, then subtract Resolution Date from Colum M" Submit Date" result is Days to Approve
This formula has been working, but isn't working today
=IF(ISBLANK(N4),"",IF(ISBLANK(N4),"",N4-M4))
(Computer upgraded to Win 10 & Office 2013 (not sure if this made a difference or not)
Column M N O
Label Submit Date Resolution Date Days to Approve
Sample1 2/16/17 2/16/17 0
Sample 2 2/6/17 blank blank
Sample 3 2/6/17 2/7/17 2
Help Please
Bookmarks