You can format dates any way you like, but it will always store a date as a number, if you want to do lookups on a date enter the lookup as follws:-

lookup(date(YYYY.MM,DD),A:B)

This will then look for the date entered in the above formula in column A and return the value in B