Ben Wingrove Posted February 13, 2017 Share Posted February 13, 2017 I am trying to get a worksheet to return the most recent date from a range of cells using the =MAX(A1..A30) function. I have made sure the cells are formatted for a date but it doesn't appear to be working! is there a different function I should be using for a date? Thanks Ben Quote Link to comment
Pat Stanford Posted February 13, 2017 Share Posted February 13, 2017 I just tried Max on a range of dates here and it worked fine. I used a smaller range, but other than that just like what you had. What are the values in your range of dates? Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.