VLOOKUP is data type of TEXT instead of DATE - sorting is off

Todd JardineTodd Jardine ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions
04/04/19 Edited 12/09/19

I am currently creating an report which looks up dates based on specific milestone tasks over a number of project sheets.

When the vlookup calculation is entered and I hit the Return key, is it giving me an alert that the value is not in date format.  Being the admin, I am able to override this.  But when sorting, it sorts dates as numbers, not as dates (sorts by the first numeral digit instead of year/ day/ month).


1. All vlookups are pulling from a column that with a data type of Date (as selected in column options)

2. Destination column in report has a datatype of Date (as selected in column options).


Any help on this would be appreciated.





Sign In or Register to comment.