ExcelBanter - Show latest date in a column

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Show latest date in a column (https://www.excelbanter.com/excel-discussion-misc-queries/215300-show-latest-date-column.html)

Jim

Show latest date in a column

Hello,

What formula can I use to show the latest date in a column?

Thanks

Mike H

Show latest date in a column

Hi,

Excel dates are numbers so

=MAX(E:E)

Mike

"Jim" wrote:

Hello,

What formula can I use to show the latest date in a column?

Thanks

David Biddulph[_2_]

Show latest date in a column

=MAX(A1:A100)
--
David Biddulph

Jim wrote:
Hello,

What formula can I use to show the latest date in a column?

Thanks

All times are GMT +1. The time now is 03:48 PM.