Need help with dates

[Njones]

I have a pay table that shows the week ending date in the last column in the format of 09/13/05, I want to seperate this into different columns by month, day, year using code, how would I do this. Is there any string manipulate technique I could use? Please help