[solved]Auto Sequence Date of of previous entry

[kamelkid2]

im developing a spreadsheet for end users that will assign the day of the week based off of the date and give feedback based on that. what im looking for is a way to foolproof the spreadsheet so they enter day 0, and excel will auto fill the dates after that to reduce chances of them screwing up (31 days in november, forgetting leap year, etc)

so my sheet looks like this:

a1 = 11/15/2011
a2 = 11/16/2011
a3 = 11/17/2011

and so on

what im looking for is a simple statement that will look at cell a3, and apply 11/18/2011 in a4. does something like this exist? non-vba preferred if possible

thank you for your help

[estige]

Maybe I have misunderstood, but if you want A4 to add one day to A3, you can just add 1: A4=

Please Login or Register  to view this content.

[kamelkid2]

oh. well dont i look silly. didnt occur for me to try that. thank you (:

[estige]

no problem