I created a spreadsheet for use as a personal time log but the trouble is that I cannot figure out how to create a formula or macro to accomplish my objective here.

I searched the forum and found a variety of answers that are semi related but aren't quite the same as what I need. I haven't been able to figure out how to modify a previously posted formula to meet my needs either. I also did some research into offset, the Dim command and arrays and various macro tutorials without any success whatsoever.

Attached is the spreadsheet but for anyone who does not want to open it:

Cell A1 contains the column header "Date"
Cells A2-A32 contain 03/08/2014
Cell A33 contains the column header "Date"
Cell A34 should contain 03/09/2014
Cells A34-A64 should contain 03/09/2014
Cell A65 contains the column header "Date"
Etc...

The ideal solution would either apply this pattern to cover a 1 year range or allow it to be applied to as many cells as desired.

Help would be greatly appreciated.

Time Log.xlsx