Good Afternoon! I am working on a spreadsheet calendar for my work and I am
having a issue with the date reflecting the month the user puts into the
sheet.
A1 is where the user will type in the date such as august 2008. I have
columns A thru G for the days in the week but I would like the have the date
autofill the boxes on the calendar.

So A4 is Sunday G4 is Friday and then A12 is Sunday G12 is Friday (2nd week)