+ Reply to Thread
Results 1 to 2 of 2

date increment on printout

  1. #1
    Registered User
    Join Date
    01-27-2009
    Location
    Australia
    MS-Off Ver
    Excel 2002, 2010
    Posts
    42

    date increment on printout

    Hi all,

    I have excel 2013.
    Say, in the Cell A1 it contains the today's date : 1st, March, 2019.
    And now I want to print 10 pages that the date will inrement by 1 like this:
    Page 1: 1st, March, 2019.
    Page 2: 2nd, March, 2019.
    Page 3: 3rd, March, 2019.
    .
    .
    .
    Page 10: 10th, March, 2019.

    How to write a macro for this?
    Or it can be done in print setting somewhere?

    Thank you!

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,743

    Re: date increment on printout

    Something like:

    Please Login or Register  to view this content.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Increment from first date till end date of given Month
    By acsishere in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-28-2018, 12:25 PM
  2. Macro to start with a date, increment the date and save as new workbook
    By snkhan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-22-2017, 03:34 PM
  3. Date range printout
    By milleroy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-09-2014, 08:52 AM
  4. Replies: 1
    Last Post: 12-15-2011, 05:32 AM
  5. Posting future date on printout
    By Rickl in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-06-2011, 10:23 AM
  6. date increment how?
    By exolim in forum Excel General
    Replies: 3
    Last Post: 02-21-2008, 08:27 PM
  7. Date in VBA Code Printout
    By BillCPA in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-05-2005, 05:05 PM

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