Hello again,

This problem seems quite simple but I am not having an easy time of it.

The situation is that I have 2 sheets. Dates are entered in column A on one of the sheets. I have a formula in cell A3 of the next sheet to find the minimum date charted on the first sheet. The issue is that I need the A column on the second sheet to use that minimum date and then autofill the rest of the column.

Example:

Sheet 1

The first date entered is 2-Jan-2012

Sheet 2

Cell A3 - 2-Jan-2012

What I need is a way for the remainder of column A to continue on from there in 1 day increments so...

Sheet 2

Cell A3 - 2 Jan-2012
Cell A4 - 3-Jan-2012
Cell A5 - 4-Jan-2012

The reason I cannot just autofill the dates is that I won't know what day the first date will be. Hence, my desire to have a formula that will take cell A3 and add 1 day for A4 and then 2 days for A5, etc...

I tried using the formula A4=A3+1 and then autofilling but I found it kept repeating.

Thanks,

Graham