+ Reply to Thread
Results 1 to 2 of 2

Auto Date Fill

  1. #1
    Registered User
    Join Date
    12-31-2014
    Location
    Dallas, Texas
    MS-Off Ver
    2013
    Posts
    1

    Auto Date Fill

    I need a simple formula. I need to be able to enter a specific date and then have adjacent cells in a row auto fill dates of 14 days intervals.

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: Auto Date Fill

    Say you enter a date into cell A1. In A2, enter: A1+14

    Then you can copy/paste (or drag) the formula through the specified number of cells within the same row that you need.
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

+ 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. Auto Fill due date
    By shanem11 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-29-2012, 11:23 AM
  2. Auto fill date
    By scorpioscouse in forum Excel General
    Replies: 2
    Last Post: 11-14-2008, 05:34 AM
  3. Date auto fill
    By KellyPSmith in forum Excel General
    Replies: 2
    Last Post: 08-04-2008, 02:17 PM
  4. Auto Date Fill
    By martins in forum Excel General
    Replies: 5
    Last Post: 08-29-2006, 06:52 AM
  5. [SOLVED] Auto Date Fill-in
    By Dreamweavn via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-30-2005, 05:06 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