Auto Fill "Missing" based on two dates values

Hi All,

I have two date columns.

My requirement is, in the 2nd column word "Missing" should be filled if difference between [Today] and [Date in 1st column] is more than two days. Also user may enter some date value in 2nd column. In that case "Missing" should not be filled.

I can use 1 or more columns for intermediate calculations.

I have attached a sample file. In that cell "B3" should be auto-filled with "Missing" but not cells "B5"

PLEASE have a look and help me!