ExcelBanter - How do I autodate(excel) every 7 days ex. 1/1/06-1/31/06?

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

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - How do I autodate(excel) every 7 days ex. 1/1/06-1/31/06? (https://www.excelbanter.com/new-users-excel/64898-how-do-i-autodate-excel-every-7-days-ex-1-1-06-1-31-06-a.html)

tlk1214

How do I autodate(excel) every 7 days ex. 1/1/06-1/31/06?

Gord Dibben

How do I autodate(excel) every 7 days ex. 1/1/06-1/31/06?

Enter 1/1/2006 in A1

In A2 enter =A1+7

Drag/copy down.

Gord Dibben MS Excel MVP

On Thu, 12 Jan 2006 11:36:03 -0800, "tlk1214"
wrote:

All times are GMT +1. The time now is 03:58 PM.