ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Automotic date change for schedules (https://www.excelbanter.com/excel-discussion-misc-queries/60633-automotic-date-change-schedules.html)

Josh

Automotic date change for schedules
 
We want the dates for all the days on our schedule to change when we put in
the starting date for that schedule

Gord Dibben

Automotic date change for schedules
 
Josh

Date in A1

In A2 enter =A1 + 1

Drag/copy down.

Change date in A1 and all will change.

Your layout is probably not that simple, but the idea is the same.


Gord Dibben Excel MVP

On Thu, 15 Dec 2005 10:31:02 -0800, "Josh"
wrote:

We want the dates for all the days on our schedule to change when we put in
the starting date for that schedule


Vito

Automotic date change for schedules
 

Change how? As a function of the entered date? Please elaborate.


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=493885



All times are GMT +1. The time now is 05:24 PM.

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