Scheduled vs Actual Date

[horizonflame]

Hello,

In column A I have the scheduled date for a task to be done. In column B I input the real date of task when it is done. In Column C I want to reference the real date if entered, or if real date is blank reference the scheduled date.

Can someone suggest a formula please?

Thank you!

 

[kgkev]

I think this should work

=IF(B1="",A1,B1)

 

[horizonflame]

Thank you kgkev, that works great ?