kmayhew
New Member
- Joined
- Jul 12, 2011
- Messages
- 7
I am using Excel 2010 on Win7.
I have a list of short dates (dd-mmm-yy) in a single column, A2:A20.
On the same tab, I am using
to find the most recent date in the list (so that I can know the most recent invoice date for that project). It works just fine here and I do indeed get the most recent date and in the proper format.
In a different workbook being used as a summary overview for multiple projects, I am using
. The result here is *always* the date one day and four years before the correct date.
Example: if the correct most recent date is June 1, 2011; the result displayed by the above formula is May 31, 2007.
My attempt to correct: on the original worksheet, I created a cell of =MAX(A2:A20) and the result is correct. On Summary Worksheet, I enter "=" and then go click on that result cell in the original spreadsheet. My thinking was that perhaps if all I want to do is *see* the result, then maybe there won't be an error.
But the displayed result in the summary worksheets is still one day + four years before the actual result shown in the original file. It works fine from another tab in the same file, but not across files.
Pulling other data into the summary page works fine. The only error is in this date.
Ideas?
I have a list of short dates (dd-mmm-yy) in a single column, A2:A20.
On the same tab, I am using
Code:
=MAX(A2:A20)In a different workbook being used as a summary overview for multiple projects, I am using
Code:
=MAX('[another_worksheet.xlsm]Invoice Record'!$A$2:$A$20)Example: if the correct most recent date is June 1, 2011; the result displayed by the above formula is May 31, 2007.
My attempt to correct: on the original worksheet, I created a cell of =MAX(A2:A20) and the result is correct. On Summary Worksheet, I enter "=" and then go click on that result cell in the original spreadsheet. My thinking was that perhaps if all I want to do is *see* the result, then maybe there won't be an error.
But the displayed result in the summary worksheets is still one day + four years before the actual result shown in the original file. It works fine from another tab in the same file, but not across files.
Pulling other data into the summary page works fine. The only error is in this date.
Ideas?
