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).

Note:

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.

Todd

 

 

Comments

Sign In or Register to comment.