ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Date (https://www.excelbanter.com/excel-discussion-misc-queries/69498-re-date.html)

dlw

Date
 
you can enter the first two dates, highlight them, then use the "fill handle"
to pull down the rest.

"Boenerge" wrote:

Is it possible to set up a function that will insert dates in 1 week
increments in a spreadsheet from a given date e.g.
insert:
01/01/01
then following dates down the column are inserted as follows:
08/01/01
15/01/01
22/01/01
29/01/01
etc.
Thanks for help in advance



All times are GMT +1. The time now is 05:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com