I have a list of customers that use different code dates. Some use a MM/DD/YY format while others use a Mmm/dd/YY while others use a mm/dd/yyyy numeric and there are still more variations. I am trying to build an array that looks up these customers with their products and have their code date driven from a common date provided by the user. This will give a correct code date for a production schedule.

The problem I face is Excel doent like to copy dates to other cells. If the date is formated as Jun1809 the lookup function displays 39982. There are times when I need to concantenate "Best by" and the date. I get "Best by 39982" as a result.

Is there a way around this? Through a function or visual basic macro?

Thanks,
Kurt