Hello.
I am trying to calculate the number of days between to dates, however not all cells have dates in.
For those cells that are populated I am getting the correct answer by using the formula: =Cell - Cell. However if there is cell is not populated currently, I get an error of #value.
What formula should I use to get rid of this error and return with no data, unless the dates are populated in the future?
Thank you
Bookmarks