Determine Max Date

Question

I'm having an issue with trying to get Excel to display the latest/max date in a series of 6 fields (all in the same row) - saved in the Date format mm/dd/yyyy.  I've tried changing to the alter format of dd month yyyy (eg 20 December 2018) but continue to get a #Value - even though the Evaluation steps shows the correct Serial Number for the date.

I'm working on a shared system so I don't have the ability to change the Date Format for all.

This seems too simple to be this problematic - just want to be able to change any of the (6) dates and have the 'display' cell show the that later date - as opposed to having to do this manually. 

Any suggestions or formulas to try?

Appreciate any assistance.

Answer 1

Hi Brian,

To change the format of the dates, present in Excel workbook, follow the below steps:

a. Select the cells which you want to change the date format.

b. Click Ctrl + 1> In the Number tab, select the Datein the Category.

c. Select the format as per your requirement in the Type> Ok

If you don’t have the format as your requirement, you can create a custom date format, you can refer to this article: Format a date the way you want.

You can use the Function provided by HansV, to get the later date among the selected dates.

Thanks,

Chitrahaas

Answer 2

Hi Brian,

Have you tried the steps provided in above reply? Please let us know, if you still need any help.

Thanks,

Chitrahaas

Answer 3

Something like

=MAX(A2:F2)