MAX COLLECT for dates in a row


I have a certification that requires a few lessons to be fully certified. Each lesson has a completion date in it's own column and a date column for when they become fully certified. So, if there if one training is missing a completion date they are not considered fully certified.

My need is to be able to collect the max date of the all training completions for that certification per the employee. This would be collecting the max date for rows, not columns. Is this possible?

Thank you - Ron

Best Answer