Forum Discussion

Copper Contributor

Dec 14, 2022

Solved

Counting Days Once A Submission Date is Entered and Stops Counting Once a Closed Date is Entered

Good Day All! I am new here to the discussion boards, but I am in a pickle here. I am creating a database to track Error Reports within my organization. The cells I am having trouble with...

excel

Formulas and Functions

Jihad Al-Jarady
Dec 14, 2022
Hi travisrussell

Write this formula in cell J3:
=IF(F3<>0,IF(O3<>0,O3-F3,TODAY()-F3),"")

Jihad Al-Jarady

MCT

Dec 14, 2022

Hi travisrussell

Write this formula in cell J3:

=IF(F3<>0,IF(O3<>0,O3-F3,TODAY()-F3),"")

travisrussell
Copper Contributor
Dec 14, 2022
Jihad Al-Jarady Thank you so much. It works! I appreciate your time and your willingness to help! Cheers