Date functions in PowerPoint 97

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a presentation for a seminar that lasts 7 days. On the first day I will give anouncements of what will be occouring over the next seven days.

I want to display the Day, date and month and year on each slide as follows.

I want to capture the system date, for example on Sunday April 25, 2004 and display that date on the first slide, then increment that date for the date on each of the next 6 slides to display the correct date. Anyone know of a way to do this in PowerPoint 97 vua Visual BAsic or some other way?

Slide for Sunday
Sunday April 25, 2004

Slide for Monday
Sunday April 26, 2004

Slide for Tuesday
Sunday April 27, 2004

Slide for Wednesday
Sunday April 28, 2004

Slide for Thursday
Sunday April 29, 2004

Slide for Friday
Sunday April 30, 2004

Slide for Saturday
Sunday May 1, 2004

Thanks

Rob White
 
Rob, this is possible using VBA, and getting the code written would probably only take a
couple hundred times longer than it'd take to copy/paste the Sunday slide text to each
subsequent location and edit it by hand. ;-)

Some things aren't worth automating.


I am trying to create a presentation for a seminar that lasts 7 days. On the first day I
Click to expand...
will give anouncements of what will be occouring over the next seven days.
I want to display the Day, date and month and year on each slide as follows.

I want to capture the system date, for example on Sunday April 25, 2004 and display that
Click to expand...
date on the first slide, then increment that date for the date on each of the next 6 slides
to display the correct date. Anyone know of a way to do this in PowerPoint 97 vua Visual
BAsic or some other way?
 
Rob, In additon to Steve's comments, I'd probably do it with links to
an Excel workbook. As much as I don't use links this might make sense.
Actually, I'd probably just go get the data from and excel workbook
and change the text string in PPT, but it's easier to explain as a
link.

In an Excel workbook that has been saved, type in A1 the starting date
you want and format it as you see fit in the Format Date dialog. Then
in A2 type in the formula "=A1+1" to get the next day. Then copy A2
down as many days as you want into new cells. I get the following in
Excel which you could link to (did I say link again, oh my?)

Thursday, January 01, 2004
Friday, January 02, 2004
Saturday, January 03, 2004
Sunday, January 04, 2004
Monday, January 05, 2004
Tuesday, January 06, 2004
Wednesday, January 07, 2004


In my case I started with the cell being 1/1/2004 and formatted to
include the Day.

Again this could be done entirely in PPT but when you can use a faster
tool like Excel for date formatting, why not?

Brian Reilly, PowerPoint MVP
 
Back
Top