Calculating how many days passed (between 2 dates)
I am wondering if you can help.
I have a very basic formula in place to calculate how many days passed from date 1 to date 2. I used NETDAYS formula. Since we use it to calculate the time from when the issue was raised until it was resolved - the end date is not always there straightaway which of course brings back #INVALID DATA TYPE error.
Is there a way for the column to stay clear until the end date is provided so the calculation can be done and the correct number can appear in the column? The sheet is to be shared with top management and I'm trying to make it as clear as possible.
I'd appreciate all the suggestions.
Help Article Resources
Check out the Formula Handbook template!