One way:

A7: =A3+1

Format A7 as a date.

In article ,
"slewis3" wrote:

how do I get dates to change automatically in different cells, i.e. I type in
01/01 in a3 and want 01/02 to appear in a7?