SOLVED

Need Formula to capture to latest date from a group

Copper 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.

 

HighFiveEm_1-1639169657424.png

Please help,

 

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution
Hi,

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.

AH
Thank you, that worked just perfect.
1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution
Hi,

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.

AH

View solution in original post