Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-11-2016, 05:20 AM
GavinHar GavinHar is offline increasing dates across college timetable by 40 days Windows 7 32bit increasing dates across college timetable by 40 days Office 2007
Novice
increasing dates across college timetable by 40 days
 
Join Date: Mar 2016
Posts: 2
GavinHar is on a distinguished road
Default increasing dates across college timetable by 40 days

I have a college timetable that ran from January to March 2016. it was produced in MS Word in a series of tables. Our next timetable will run from April to July. We are keeping the same courses so simply want to copy the JanMarch timetable into the beginning of the April Jul period. the only variable is the Day and date in separate but adjacent cells fields.
the Date is formatted "Month Date" sometimes "Month Date" with 3 different dates for a course that lasts a day but runs on three consecutive months and sometimes "Month Date - Month Date" showing the first date and last date for a course that runs one day a week for up to 8 weeks.
Regards,
GavinHar
Reply With Quote
  #2  
Old 03-11-2016, 02:11 PM
macropod's Avatar
macropod macropod is online now increasing dates across college timetable by 40 days Windows 7 64bit increasing dates across college timetable by 40 days 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

You would do better to create this in Excel, as that application can do date calculations far more easily than Word. That said, to see how to do this and just about everything else you might want to do with dates in Word, check out my Microsoft Word Date Calculation Tutorial, at:
http://windowssecrets.com/forums/sho...ation-Tutorial
or:
http://www.gmayor.com/downloads.htm#Third_party
In particular, look at the item titled Calculate a Date Sequence. Do read the document's introductory material.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 03-15-2016, 04:03 AM
GavinHar GavinHar is offline increasing dates across college timetable by 40 days Windows 7 32bit increasing dates across college timetable by 40 days Office 2007
Novice
increasing dates across college timetable by 40 days
 
Join Date: Mar 2016
Posts: 2
GavinHar is on a distinguished road
Default

Thanks Paul. I'm working through the papers you linked to.
Gavin
Reply With Quote
Reply

Tags
date, timetable

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
increasing dates across college timetable by 40 days Calculating Quarterly Dates by Months not Days Artboy34 Excel 3 01-28-2016 09:47 AM
Start / End Dates in conjunction with man days loobs40 Project 5 09-19-2013 09:21 AM
increasing dates across college timetable by 40 days Help with increasing multiplier in adjoing cells Joanne Excel 2 08-02-2013 06:38 AM
increasing dates across college timetable by 40 days cheat(increasing) word count akbareshghi Word 2 04-03-2012 10:29 AM
increasing envelope address window seemore Mail Merge 0 02-14-2011 12:18 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:18 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