return max date not working correctly

[cthorn112]

I have the following dates 4/1/2011, 4/2/2011, 4/8/2011, 4/9/2011, 4/15/2011, and 4/16/2011. If I ask to return the max date it returns 4/2/2011 instead of returning 4/16/2011. I believe this is due to the fact that excel treats 4/2/2011 as is instead of 4/02/2011. I have one possible solution which might seem like more work then needed (writing code that will add a leading 0 if the day is only 1 digit). Before going down that path does anyone have any ideas or suggestions ? Please let me know and thanks in advance.

Dim job_completed As Range

Set job_completed = Sheets("PROMOTER_TEMPLATE2").Range("B16:B21")
Sheets("PROMOTER_TEMPLATE2").Range("B12").Value = Application.WorksheetFunction.Max(job_completed)

-Chris

 

[cthorn112]

I found the problem. I did not have the correct range (noob mistake). It works fine now.

-Chris