Excel How to Get the Last Date in a Column

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

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

[darylvondunker]

Brilliant!

Love this.

I can’t tell you how many times I’ve set up workshop dates in at a company convention in conjunction with employees signing up for shared rooms.

Typically, employees have multiple timeframe windows to get their rooms and various discounts for room signup (early bird, middle season, late bird), knowing the date range when 1, 000s of people come from across the country would have made my life so much easier. Then, I could have set up dependent functions for issuing the room and ticket discounts.

Thank you Jeff. I appreciate your kindness and wisdom!

[zanquinoe.s.]

Thank you for all the content.

Any tips regarding fixing the “Formula Bar” font changing when displaying a formula?

For example, when you click the CELL the formula bar presents a FONT but when you press the formula bar to make changes the FONT changes making me double click the bar to reposition.

[brianb]

Jeff, your videos are great. Finding the last row is always useful.
But could you help me understand why this works? Why is MATCH returning 80?
First, MS says our array has to be sorted in descending order. Obviously, that's not the case here. Your dates are varied, and not sorted (I'm guessing this was updated and hasn't found its way to the documentation perhaps?). Second, MS says MATCH w/-1 "finds the smallest value that is greater than or equal to lookup_value" We're looking for zero, excel sees dates as numbers, so it seems like this should return the first date that is greater than the lookup value, or earliest date.
It almost seems as if we're sending MATCH out to look for 0. It finds zero at row, or index position 22. We used -1 as our match type, so it is returning the "smallest value", greater than, or equal to our index match value - 22-1=21. And what they mean by "value" is the index value, not the lookup value? MS documentation clearly seems to indicate value as in lookup value, so I find it a bit confusing.
Thanks again!

[cdeitschel]

Thanks for the video. For exercise 3, let's suppose I wanted to know the max date for each vendor (assuming each vendor had multiple dates). What would be the formula then?

[Colin-wy]

I am looking to make a cell time/date stamp when marking another cell "complete".

Example: Creating a Conditional Formatting Rule =$F3="Y" to mark a column a color identifying this as completed. I would like to create a "Date/Time" stamp to coincide when that box is marked "Y".

Does anyone know a way for me to make this happen?