Copy A Value Between 2 Fields Based on Condition

Hi MOSC.

I have 2 Date Picker fields.

   - Date1Schedule ==> date linked from schedule sheet

   - Date1Manual ==> manually inputted by user

I have a field called P6ScheduleExist with values Yes or No. If P6ScheduleExist is Yes, Date1Manual will be cleared and disabled.

What I need to accomplish is this:

A new Date1Live field is added. This should contain the value of either Date1Schedule or Date1Manual based on the P6ScheduleExist value.

Date1Live

- if P6ScheduleExist is equal to Yes, value should be equal to Date1Schedule.

- else, value should be equal to Date1Manual.