Excel Formula Help Needed (Date Field Populated Calculate)

[msvoboda27]

HI

I am working on a project status report if a date field is populated then calulate a % in a differnet cell.
I have 4 steps in the process each 25% to complete


if excel date field populated then add 20% to complted project
[TABLE="width: 100"]
<tbody>[TR]
[TD][/TD]
[TD]a[/TD]
[TD]b[/TD]
[TD]c[/TD]
[TD]d[/TD]
[TD]e[/TD]
[TD]f[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]% Completed[/TD]
[TD]25%[/TD]
[TD]25%[/TD]
[TD]25%[/TD]
[TD]25%[/TD]
[TD]% Complete[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]step in process[/TD]
[TD]requirments[/TD]
[TD]code[/TD]
[TD]unit test[/TD]
[TD]promote prod[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]date completed[/TD]
[TD]9/8/17[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]25%[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
If date field populated then add 25% too completion of project
=if cell b3 populated with date then calculate cell b1, if date field not updated dont calculate
trying to calucate % complete cells b1:e1) = total % complete for project.
Hope that makes sense
Thank YOU for time and support.
Michael