Formula combining Help

[LP321]

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

[dilipborad]

Hello @LP321 

Use this and change field names accordingly.

IF({MOC Submitted},IF(IS_AFTER(TODAY(), {MOC Requested}),  DATETIME_DIFF({MOC Submitted}, {MOC Requested}, 'days')),IF(IS_AFTER(TODAY(), {MOC Requested}),  DATETIME_DIFF(TODAY(), {MOC Requested}, 'days')))

I hope this helps 👍 

If it's helps then mark it as a solution.

[LP321]

This worked perfectly. Thanks!