Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-20-2012, 12:45 AM
PaperBuster PaperBuster is offline How to change dates automatically Windows XP How to change dates automatically Office 2003
Novice
How to change dates automatically
 
Join Date: Sep 2012
Posts: 2
PaperBuster is on a distinguished road
Default 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.
Attached Images
File Type: png problem.PNG (42.9 KB, 15 views)
Reply With Quote
  #2  
Old 09-21-2012, 03:36 AM
macropod's Avatar
macropod macropod is offline How to change dates automatically Windows 7 64bit How to change dates automatically Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

See: https://www.msofficeforums.com/word/...html#post34394
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 09-21-2012, 06:56 AM
Charles Kenyon Charles Kenyon is offline How to change dates automatically Windows Vista How to change dates automatically Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,081
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

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.
Reply With Quote
  #4  
Old 09-24-2012, 06:29 AM
PaperBuster PaperBuster is offline How to change dates automatically Windows XP How to change dates automatically Office 2003
Novice
How to change dates automatically
 
Join Date: Sep 2012
Posts: 2
PaperBuster is on a distinguished road
Default

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.
Reply With Quote
  #5  
Old 09-24-2012, 08:02 AM
Charles Kenyon Charles Kenyon is offline How to change dates automatically Windows Vista How to change dates automatically Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,081
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

It would definitely be easier in Excel.
Reply With Quote
  #6  
Old 09-24-2012, 09:31 PM
macropod's Avatar
macropod macropod is offline How to change dates automatically Windows 7 64bit How to change dates automatically Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by PaperBuster View Post
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.
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]
Reply With Quote
Reply

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
How to change dates automatically 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:07 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft