a column (E) of cells each containing options from a dropdown list named
Depending on which option i choose i need the cell on the same row in column (H) to run a formula that counts down days from the current date, that will run into negative days past due.
"MINOR" 10 days
"MAJOR' 5 days
"CRITICAL" 1 day
If possible i then need that countdown to stop when I enter the current date in cell on same row column (I)