View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jenn P. Jenn P. is offline
external usenet poster
 
Posts: 1
Default Printing schedule with auto increment workday date

Hi,

I'm trying to set up what I think should be a macro that runs on a print
event.

I have an office schedule that I print out for others to fill in. I'd like
the date in merged cells c1:j1 to have the date (dddd, mmmm d, yyyy) be in
that cell and automatically increase by 1 day for every page printed out,
excluding Saturday and Sunday. Is this possible?

I've been trying to figure out a way and so far have failed. Does anyone
have any hints, suggestions, or tips that'll get me going in the right
direction?

Much appreciated!