I have a worksheet that will hold dates of completion of projects.
I want to put dates in cells adjacent to a persons name, name in B4, C4L4
will have dates put in them. I want M4 to show the last date entered. If C4,
D4,E4 and F4 have dates M4 will show F4 date. or if C4, D4,E4,F4,G4,H4,I4
have dates M4 will show I4 date

Is there a formula that can do this? I have tried a couple of ways and
cannot get it to show the right date.

Thanks for your help

Steve