I have a formula that finds and returns the maximum of a set of date cells meaning that it finds the latest date. It works fine if all cells are populated with dates but if one cell is blank it error out. This is the formula:
=MAX([Due Date]1, [Family Member A Due Date]1, [Family Member B Due Date]1, [Family Member C Due Date]1, [Family Member D Due Date]1, [Family Member E Due Date]1)
How can I fix it to still return the MAX value if any of the cells for Members A, B, C, D, or E are blank?
Thank you