PDA

View Full Version : Compare Date Columns In Excel And Pull The Latest Date



marentette010
07-31-2013, 11:47 PM
I am trying to compare 4 columns in excel, each with a date. I need to be able to compare all 4 against each other and have a 5th column be the most recent date. I found something similar in the following thread:

http://www.excelfox.com/forum/f2/vba-program-to-compare-4-columns-in-excel-required-1145/index2.html (I hope I did this right). If I click on the code it gives me this huge grey box. Is this a macro or something? If so, I would like to be able to do the same thing only with dates. How would I create this in my spreadsheet?

Excel Fox
07-31-2013, 11:56 PM
Why don't you just use a formula. If your dates are in B2,C2,D2 and E2, a formula in F2 = MAX(B2:E2) will give you the latest date.