I am trying to create a new tracking sheet, and it focuses around this forumula I can't seem to find out how to fix. The formula I'm working with is below:
=IF(C3="",TODAY()-A3,C3-A3)
My objective was to create a tracking formula so I could put a date into a cell when notification was received/sent (A3), then have the cell next to it start counting(B3, also where the formula is located). Once that issue was resolved, I would input a date in the other cell (C3), which would them override the “today()” function, and do the subtraction portion (Also stopping an endless number count). This would show how long it takes for responses to have quick overview of how many days it took to respond to each issue.
My current dilemma is that when cell A3 is blank, the formula cell displays a sample number 43313. I'm not sure why it wont just show a blank cell when there is no data to grab from. Is there a way to fix it so it wont show this? I have tried everything I can think of, but nothing works.
Related:
How to stop today function date changing every day in excel
Stop counting days in excel when status is changed - Best answers
That sample number you mention is actually an Excel code for date (select that cell, hit Ctrl+1 and change the format to date). That date is either today's date or the value in C3.
When you want the result to be blank when A3 is blank, you will need to nest another IF function:
=IF(A3="","",IF(C3="",TODAY()-A3,C3-A3))
