I’m trying to get the project dismissal date to appear on the “Report” sheet when keyed into the “Master” sheet. Trying to keep from having to enter twice.

This is the formula used, but if the cell on the Master sheet is blank (no date has been entered) then on the Report sheet it shows 3/30/00 in the Dismissal Date column, even if it hasn’t been dismissed.
=SUMPRODUCT((‘Master’!$A$2:$A$5182=A4)*(‘Master'!$E$2:$E$5182="dismissed"),‘Master'!$G$2:$G$5182)+90

I tried to format by customizing the date column on the Report with mmddyy;;;@

On the Report sheet, I need the Dismissal Date column to be blank until the date is entered on the Master sheet.

Any help is greatly appreciated.