Logic syntax in excel
Cell N2 is an automatically updating cell showing today's date
Cell K5 shows the date an individual began a certain status; (obviously, if the individual has not begun that status, K5 will be blank)
I want cell Q5 to show "0" if the individual has not begun that status (if K5 is blank) OR to show the number of days since he began that status to present (N2-K5).
I'm not clear on how to write this logical argument
=if(K5="",0,N2-K5)
=if(K5="",0,N2-K5)