Hi, sorry if wrong spot (first post).
I've set up a spreadsheet for staff to put in a start date (H column) and a second column (I) that will say how long the case has been open.
I've used =TODAY()-K2 which gives me the correct answer, so that's working well.
However there's extra space at the bottom for more entries that may be needed which are blank, but the formula is throwing in a random number (guessing it's a number with a 1990 start date or something...)
Is there a way to have the above formula, but then if the H cell is blank, to just stay blank?
In the picture below I want the 45519 cells to be blank.
I've set up a spreadsheet for staff to put in a start date (H column) and a second column (I) that will say how long the case has been open.
I've used =TODAY()-K2 which gives me the correct answer, so that's working well.
However there's extra space at the bottom for more entries that may be needed which are blank, but the formula is throwing in a random number (guessing it's a number with a 1990 start date or something...)
Is there a way to have the above formula, but then if the H cell is blank, to just stay blank?
In the picture below I want the 45519 cells to be blank.