Results 1 to 3 of 3

Date auto generate problem

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-17-2014
    Location
    INDIA
    MS-Off Ver
    Excel 2010
    Posts
    332

    Date auto generate problem

    Hi friends…………
    Today I am facing some problem in my formula……………Please guys help me……….

    I am uploading an excel file in which I am facing the problem………..in the spreadsheet it contains two tables…………..

    Table No. 2 is auto expending the date………if you change the start date (i.e. 01-01-2014) Col-A5 and enter the Finish Date in Col-B6(i.e. 31-12-2014), the Table No.2 is auto generate the date from 01-01-2014 to 31-12-2014 that is fine………….

    But I want result like Table No.1
    In Col-A5 I will enter the start date (i.e. 01-01-2014) and Col-B5 enter the another date but it is not finish date (i.e. 16-08-2014)………..i want (Table No.1 auto generate the date like Table No.2) that the date auto expend from 01-01-2014 (A5) to 16-08-2014 (B5) but the twist is it should shows 17-08-2014 (A6) in next row and then it again auto generate the date from 17-08-2014 to 31-12-2014 including shows the number of days in particular month…………

    Friends If you not able to understand what I want to saying please see my excel file

    Days Period
    31 01-01-2014
    28 01-02-2014
    31 01-03-2014
    30 01-04-2014
    31 01-05-2014
    30 01-06-2014
    31 01-07-2014
    16 16-08-2014
    15 17-08-2014
    30 01-09-2014
    31 01-10-2014
    30 01-11-2014
    31 01-12-2014
    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. [SOLVED] Auto Generate an ID# based on date
    By jme1013 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-13-2016, 07:21 PM
  2. [SOLVED] Auto-Generate 'record' number based on date
    By russkris in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-12-2015, 12:23 AM
  3. [SOLVED] Generate request id with date and auto number
    By star18 in forum Excel General
    Replies: 6
    Last Post: 01-06-2014, 09:19 PM
  4. Auto generate the date today but 3 years from now
    By aledrhys666 in forum Excel General
    Replies: 3
    Last Post: 07-10-2013, 09:31 AM
  5. Auto generate a date as a name for worksheets in a workbook
    By austinott in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-12-2012, 12:52 PM
  6. Auto-Generate Due Date based on Ship Date, and other things
    By cjmorin in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-18-2011, 02:51 PM
  7. formula to generate month-to-date based on auto date
    By infinitysales in forum Excel General
    Replies: 1
    Last Post: 06-27-2008, 01:09 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