Inserting Days in a Date

[NotExcel]

I use a program called Argus. The date format that I dump into Excel is mm/yy. Excel does not understand this as a date. I am trying to figure out how to convert mm/yy to mm/dd/yy. Any thoughts? I am currently trying to use and IF statement and Insert function to insert either a 30,31, or 28 depending on the month, but I cannot seem to get my hands around the problem. The first step of simple inserting a number is giving me trouble. Any help would be great.

thanks.

 

[jim may]

Excel Workbook
	A	B	C
1	mm/yy	Day	Fix
2	09/11	15	9/15/2011
Sheet1

Excel 2007

Cell Formulas
Range	Formula
C2	=DATE("20" & RIGHT(A2,2),LEFT(A2,2),B2)