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...45/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?
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.
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Posting Permissions
Reply With Quote
Bookmarks