So I figured it out on my own. Posting for anybody that might be looking for the same thing..
Table1[0].Row1[0].Date1.rawValue = Num2date(Date2Num(Date1.formattedValue, "MMM D, YYYY") +0, "MMM D, YYYY")
Table1[1].Row1[0].Date2.rawValue = Num2date(Date2Num(Date1.formattedValue, "MMM D, YYYY") +1, "MMM D, YYYY")
Table1[2].Row1[0].Date3.rawValue = Num2date(Date2Num(Date1.formattedValue, "MMM D, YYYY") +2, "MMM D, YYYY")
Table1[3].Row1[0].Date4.rawValue = Num2date(Date2Num(Date1.formattedValue, "MMM D, YYYY") +3, "MMM D, YYYY")
Table1[4].Row1[0].Date5.rawValue = Num2date(Date2Num(Date1.formattedValue, "MMM D, YYYY") +4, "MMM D, YYYY")
Table1[5].Row1[0].Date6.rawValue = Num2date(Date2Num(Date1.formattedValue, "MMM D, YYYY") +5, "MMM D, YYYY")
Table1[6].Row1[0].Date7.rawValue = Num2date(Date2Num(Date1.formattedValue, "MMM D, YYYY") +6, "MMM D, YYYY")