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, 17 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: 22,467
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 online now 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,531
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, 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: 22,467
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
  #6  
Old 09-24-2012, 08:02 AM
Charles Kenyon Charles Kenyon is online now 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,531
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
Reply



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 09:26 AM.


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