Need Formula to capture to latest date from a group

Occasional Contributor

I am looking for a formula to capture the latest date from several days.  Like for example below, the 1st row across, the last date shows 12/9/2021 but I want a formula that will insert that date in the Date Completed box.



Please help,


2 Replies
best response confirmed by Hans Vogelaar (MVP)

Assuming your latest date is in increasing order from columns B to E, then you can use the MAX function. eg if(max(b2:e2)<>0, max(b2:e2),"") . The if function covers for the blank row.

Thank you, that worked just perfect.