#1
|
|||
|
|||
How to change dates automatically
I'm trying to create an automatic weekly schedule without always having to manually write down the dates. I need to create weekly schedules for 6 month periods at a time and it is a bit time consuming to manually write the dates for each week.
I've attached a picture in order to present the problem. |
#2
|
||||
|
||||
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
See also Calculated Dates in Microsoft Word using Fields or vba
Something like this is going to be a bit of work to set up, but it can be done as a template that either starts with the current date or gives you the opportunity to input a date and sets the remaining dates. You can download DateCalc.zip by Paul Edstein which gives a wealth of date fields, as well. |
#4
|
|||
|
|||
Thank you for the hints. I actually had downloaded the datecalc file already, but could not find any help from it. I think this might be easier to be done in excel but I will give it a go and see what comes up.
|
#5
|
|||
|
|||
It would definitely be easier in Excel.
|
#6
|
||||
|
||||
The tutorial has a section on sequential dates, and the link I posted has a practical implementation of the technique in a document using formfields. Definitely easier in Excel, though. I'd only recommend using Word if absolutely necessary.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to change number format of dates | ketanco | Project | 1 | 09-11-2012 02:34 PM |
How to get project to automatically pull in task dates? | Moe Szylak | Project | 2 | 04-26-2012 12:37 PM |
Automatically update dates using a macro | matthew544 | Word VBA | 5 | 12-06-2011 03:19 AM |
Automatically change the value of one cell so that two other cells become equal | matthew544 | Excel | 5 | 09-18-2011 08:56 AM |
How can I change the colors of cells automatically based on Job Completion? | Learner7 | Excel | 0 | 07-06-2010 10:47 PM |