ExcelBanter - Date Comparison

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Date Comparison (https://www.excelbanter.com/excel-worksheet-functions/239609-date-comparison.html)

Christopher Naveen[_2_]

Date Comparison

Hi,

I Have 4 cols which has dates, i want to find out the latest date in that 4
cols. Can anyone help me on this.

Chr

Jacob Skaria

Date Comparison

Try

=MAX(A:D)
(and format the formula cell to excel date format)

If this post helps click Yes
---------------
Jacob Skaria

"Christopher Naveen" wrote:

Hi,

I Have 4 cols which has dates, i want to find out the latest date in that 4
cols. Can anyone help me on this.

Chr

All times are GMT +1. The time now is 08:00 AM.