Forum Discussion
Solved
Need Formula to capture to latest date from a group
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,
- 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
2 Replies
- 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.
