Excel How to Get the Last Date in a Column

File Download: https://www.excel-university.com/yt_grctjxzhvu4/
This short video shows how to retrieve the last date in a date column. This video includes the formulas for when the data is stored in a table AND when it is not stored in a table. Plus, it shows how to retrieve the range of dates included in the data.

Specifically:
- Table
- TAKE
- INDEX/ROWS
- INDEX/MATCH
- MIN
- MAX

Chapters in this video:
00:00 - Introduction
00:16 - Exercise 1
01:25 - Exercise 2
02:14 - Exercise 3

Subscribe here 👉 https://www.youtube.com/c/ExcelUniversityInc?sub_confirmation=1 and turn on all notifications 🔔 for MS Excel time hacks that will make you more productive!

🚀 Unlock hidden Excel tricks and hacks, and become a time-saving Excel pro 👉https://www.excel-university.com/yt_grctjxzhvu4/ ⚡️🕒 Say goodbye to late nights and spreadsheet struggles!

Also, check out these videos with time saving Excel Hacks:

Excel PivotTables for Beginners https://youtu.be/Vj8SNnat2FA

Watch VLOOKUP Hacks Playlist here https://www.youtube.com/playlist?list=PLg6394TGLU5EwVI-6MxpSZOVcoz9eEPVI

Watch VLOOKUP vs SUMIFS Playlist here https://www.youtube.com/playlist?list=PLg6394TGLU5EprSnwbRF8_jCVQKde7cjr

Watch Dynamic Arrays playlist here https://www.youtube.com/playlist?list=PLg6394TGLU5FmzOe_Pb-zapkM4cX6PDC_

Watch Treasure Maps playlist here https://www.youtube.com/playlist?list=PLg6394TGLU5FTN2vOk-J55wsCej9l-8Dn

Watch Slow to Fast playlist here https://www.youtube.com/playlist?list=PLg6394TGLU5HZ7zlZdmYrEUVAW9jYAWzE

Видео Excel How to Get the Last Date in a Column канала Excel University