Date calculation in Word 2010

Topic

New Reply

Hi, I’ve been looking around in this forum for a solution but couldn’t find quite the solution I need:
I need to create a weekly schedule in a Word 2010 document that is used and printed every Mondays, displaying the planning for the week
Like this:
Planning for the week starting on: Monday, mmm, dd, yyy
– Monday dd
..
..
– Tuesday dd
..
..
– Wednesday dd
etc

How do I insert a formula that will calculate automatically ‘every mondays’ and the following days?
I assume I cannot start with today’s date and add “+7” because if I open the sheet in the middle of the week it will not show a Monday.
Sorry if I’m unclear… and thanks for your help.

Reply | Quote

Replies

Hi Humphrey,

Welcome to the Lounge.

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://lounge.windowssecrets.com/index.php?showtopic=249902
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 | Quote

Hi there and sorry to butt in, but this topic is of interest and I was going to follow through to your link Paul, but it only returns an error/invalid link message. I’m keen to see your page re the Date sequence in Word. Would you be good enough to just check the link and post again? Many thanks.

Webmistress!

Reply | Quote

Hi webmistress,

I’ve just edited the link. It should work now. An alternative download location is:
http://www.gmayor.com/downloads.htm#Third_party

Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Reply | Quote

You might also putter about Insert – Quick Parts – Field (Date) and Building Blocks in general. (I’m looking through some of that at present myself but can’t offer a specific answer to your post.)

Reply | Quote