Download the example workbook
This tutorial will demonstrate how to calculate the max date in Excel and Google Sheets. It will also demonstrate how to lookup the max date in a list and return a corresponding value.
Calculate Max Date
You can use the MAX Function to calculate the max date in a list:
Max Date Lookup
Max Date Sum
Alternatively, you can use the SUMIF Function to total all the values associated with that date from a list:
Google Sheets – Max Date
All of the above examples work exactly the same in Google Sheets as in Excel.