Formula for 1st Column:
IF(IS_AFTER(TODAY(), {MOC Requested}), DATETIME_DIFF(TODAY(), {MOC Requested}, 'days'))
Formula for 2nd Column:
IF(IS_AFTER(TODAY(), {MOC Requested}), DATETIME_DIFF({MOC Submitted Date (from Memo of Correction)}, {MOC Requested}, 'days'))
What I would like to have is a formula (preferably in 1 column) that calculates the number of days between the 3rd column and today unless a date has been entered into the 4th column. Then I want it to show the number of days between column 3 and column 4.
I can't find a way to combine my 2 formulas
