Max Date in Excel and Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on February 6, 2023
Download Example Workbook

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.

max date


Calculate Max Date

You can use the MAX Function to calculate the max date in a list:


Max date

Max Date Lookup

After calculating the max date, you can perform a VLOOKUP (or XLOOKUP) to return a value corresponding to that date:



Max Date Sum

Alternatively, you can use the SUMIF Function to total all the values associated with that date from a list:


MAX Date SumIF

Google Sheets – Max Date

All of the above examples work exactly the same in Google Sheets as in Excel.

Max date Google

AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to Excel Formulas List