+ Reply to Thread
Results 1 to 4 of 4

Add 1 to Date - Formula Fill Down

  1. 06-29-2015, 11:47 AM #1
    ksayet
    ksayet is offline
    Registered User
    Join Date
    11-23-2013
    Location
    new york, ny
    MS-Off Ver
    Excel 2010
    Posts
    42

    Add 1 to Date - Formula Fill Down

    I'd like to ask the user how many days are in the period and then take that answer and fill in a formula in that many rows.

    I've figured out the input box but I haven't figured out how to make the formula add "1" to the above cell. The goal is to have dates in consecutive order.. 1/1/15, 1/2/15, 1/3/15, etc goinColumn A.

    Here's what I have so far... I'm stuck on getting the formula to be "add one to the above cell"
    Please Login or Register  to view this content.
    What's wrong with my formula? I get "=SUM(#REF!:XFD:XFD)" in the cells..
    Reply With QuoteRegister To Reply
  2. 06-29-2015, 11:52 AM #2
    Bishonen
    Bishonen is offline
    Valued Forum Contributor
    Join Date
    03-17-2012
    Location
    Warsaw, Poland
    MS-Off Ver
    2007/2010
    Posts
    555

    Re: Add 1 to Date - Formula Fill Down

    Whats the first date? Is it in A1? If so:

    Please Login or Register  to view this content.
    If you think that my answer was helpful, please click on the "Add to this user's Reputation" button.
    Reply With QuoteRegister To Reply
  3. 06-29-2015, 01:09 PM #3
    ksayet
    ksayet is offline
    Registered User
    Join Date
    11-23-2013
    Location
    new york, ny
    MS-Off Ver
    Excel 2010
    Posts
    42

    Re: Add 1 to Date - Formula Fill Down

    Thank you...
    Last edited by ksayet; 06-29-2015 at 01:16 PM.
    Reply With QuoteRegister To Reply
  4. 06-29-2015, 01:17 PM #4
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Add 1 to Date - Formula Fill Down

    It is not my kind of expertise, but probably the red colored text is the issue.

    Please Login or Register  to view this content.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Trying to get the date (Within COUNTIF Formula) to increment when using auto-fill feature.
    By Carmstrong227 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-04-2013, 02:24 PM
  2. Formula to fill cells based on the date in another cell
    By PowerPlayer23 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2012, 02:26 PM
  3. Fill category field if date macro/formula
    By propheta in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-16-2010, 11:53 AM
  4. formula for making date fill in automatically
    By mauibeetle in forum Excel General
    Replies: 2
    Last Post: 05-15-2009, 07:09 PM
  5. [SOLVED] Create a formula to fill in a date series without using
    By John in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-25-2005, 01:05 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1