ExcelBanter - Sequential dates in different cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Sequential dates in different cells (https://www.excelbanter.com/excel-worksheet-functions/8296-sequential-dates-different-cells.html)

slewis3

Sequential dates in different cells

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?

JE McGimpsey

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?

slewis3

THANKS!

"JE McGimpsey" wrote:

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?

All times are GMT +1. The time now is 12:37 PM.