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

	a	b	c	d	e	f
1	% Completed	25%	25%	25%	25%	% Complete
2	step in process	requirments	code	unit test	promote prod
3	date completed	9/8/17				25%
4

<tbody>
</tbody>

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