Help with the "DATE" Function

I have created a workbook that will feed dates from one worksheet into the next.  For example:  In  worksheet labeled "Hollywood", column D is titled "Drill Date" and dates will be entered in rows 7 ...