Results 1 to 4 of 4

Populate dates diffence

Threaded View

  1. #1
    Registered User
    Join Date
    02-12-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    11

    Populate dates diffence

    Hi Team,
    I have two cells one is having startdate and other is having enddate.
    Ex:startdate=8/21/2013 enddate=8/26/2013
    Now what the plan is to find the difference between the two dates and populate in the cells in excel.
    i.e. now difference is 6days including start and enddate
    I want to populate first date 8/21/2013 in B4,second 8/22 /2013in E4,third 8/23/2013 in H4 and so on until enddate comes.
    Please sugget me the way to proceed.I used auto fill to populate the date values taking the difference.
    And i also want the date to be like Aug_21 for 8/21/2013
    But its not considering the date it incrementing and printing Aug_32 also if startdate is 8/21/2013 and enddate is 9/01/2013


    8/21/2013 8/26/2013
    Aug_21 Aug_22 Aug_23
    I c co I c co I c co



    Thanks in advance
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel 2007 : More auto populate dates
    By grsnipe in forum Excel General
    Replies: 2
    Last Post: 05-10-2011, 06:57 AM
  2. Automatically Populate Dates
    By CVinje in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-28-2009, 08:35 AM
  3. Auto Populate Dates
    By Bundok@mac.com in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-20-2008, 05:28 PM
  4. populate a listbox with dates
    By inno101 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-22-2008, 07:33 AM
  5. Auto populate dates
    By waiter11 in forum Excel General
    Replies: 2
    Last Post: 05-28-2006, 04:55 AM

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