Can two date columns feed the same calculated column depending on which one is answered?

D. Buchta

I have a date column that is prepopulated based on a connection to another sheet of current employees. From this, I have calculated the number of days since an event. If these employees are no longer in my connected sheet, this date becomes a #No Match. I've created a second column of manual entry dates for these terminated employees. My goal is to get this second column to feed the same "# of days since the event". I've tried multiple 'If' statements but have not had any luck. Is there any way to feed this singular column depending on which of the two dates are populating?

Paul H

A Screenshot of your column names?

An if statement would be structured like this

=IF(ISDATE(Date1),Use Date1,Use Date2)

D. Buchta

Here are the column names I'm working with.

Paul H

@D. Buchta

Try something like this

=IF(ISDATE([Clinician 1 Hire Date]@row), NETDAYS([Clinician 1 Hire Date]@row, TODAY()), NETDAYS([Clinician 1 Hire Date (Terminated)]@row, TODAY()))