Autofill based on date in non related cell?

Thanks daddylonglegs,

however pressing F9 did not assist

i am thinking may be better to progress =A1 then =A1+1....+2 etc

i should say i am now using version 2007.