Copy dates to cells

[Kurt Lyons]

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

[protonLeah]

Given: A1 = 39982,
Then:
YEAR(A1) = 2009
MONTH(A1) = 6
DAY(A1) = 18

OR,

DATE(YEAR(A1),MONTH(A1),DAY(A1)) --> 06/18/09

[Kurt Lyons]

Awesome....Thank you