Auto change date formats

Hi all, I have a stock file that I want to change the format of the date based on a reference. I have a database on one tab with the stock codes and number of other related references and a second tab with a form.

The form is created by looking up the stock code and pulling through relevant information (mainly using INDEX, MATCH). It has a field to calculate the best before date by taking today's date (on the form) + the number of shelf life days (entered into a specific field) +90, +120 etc.

However, I want it to then format it based on a chosen format for that stock code.

Date code formats notes

1. DD/MM/YY
2. DD/MM/YYYY
3. DD.MMM
4. DD/MMM/YY
5. DD/MMM/YYYY
6. MM/DD/YY
7. MM/DD/YYYY
8. YY/MM/DD Month is: JA,FE, MR, AL, MA, JN, JL, AU, SE, OC, NO, DE
9. ddd Julian code (day of the year)


Is there away that I can give each stock code on the other tab a specific format? So that it calculates the best before date and changes the format to the specific format required?

Many thanks
Ben