+ Reply to Thread
Results 1 to 2 of 2

automatically increment date (date= day of week, month, day, year) on successive page

  1. #1
    Registered User
    Join Date
    12-14-2011
    Location
    Vancouver, B.C.
    MS-Off Ver
    Excel 2003
    Posts
    2

    automatically increment date (date= day of week, month, day, year) on successive page

    Increment Date Based on Number of Pages Printed
    I have a 1 page form.
    I need to have the date printed and increment forward 1 day for each page I print.
    I do not want to have to manually enter in the date on each page

    Is there a way to make it so that if I print 30 or 31 pages it will give me a
    different date for each page?

  2. #2
    Forum Contributor ianh's Avatar
    Join Date
    11-19-2010
    Location
    Newcastle
    MS-Off Ver
    Excel 2010
    Posts
    114

    Re: automatically increment date (date= day of week, month, day, year) on successive

    The code below will add increment the day by one and then print.
    You can set the number of loops/days you want printing by setting the Nform = "value" where noted.Sample attached just run macro 4
    dateadd.xlsm

    Please Login or Register  to view this content.
    2+2=5 for extremely large values of 2.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1