+ Reply to Thread
Results 1 to 16 of 16

Date Range

  1. 08-22-2014, 03:03 AM #1
    kavin
    kavin is offline
    Registered User
    Join Date
    06-23-2010
    Location
    *
    MS-Off Ver
    Excel 2010
    Posts
    58

    Date Range

    Hi please check attached file.I want following formulas in this .
    Calculation according to selectable start date and end date period http://i.imgur.com/h3ksvSg.jpg
    data is in sheet 2


    please check file pl2 with desired results




    regards
    Attached Files Attached Files
    Last edited by kavin; 08-22-2014 at 04:14 AM.
    Reply With QuoteRegister To Reply
  2. 08-22-2014, 03:25 AM #2
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Date Range

    you could do yourself a favour, if you add the desired (expected) result in your excel file.
    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
  3. 08-22-2014, 02:55 PM #3
    kavin
    kavin is offline
    Registered User
    Join Date
    06-23-2010
    Location
    *
    MS-Off Ver
    Excel 2010
    Posts
    58

    Re: Date Range

    "Bump"..........
    Reply With QuoteRegister To Reply
  4. 08-22-2014, 07:58 PM #4
    boopathiraja
    boopathiraja is offline
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: Date Range

    Try with the below array formulas (confirm with ctrl+shift+enter)

    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    ☚ Click ★ just below left if it helps, Boo?ath?
    Reply With QuoteRegister To Reply
  5. 08-22-2014, 10:19 PM #5
    Vikas_Gautam
    Vikas_Gautam is offline
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Thumbs up Re: Date Range

    Got the solution..

    Check the attachment..
    Attached Files Attached Files
    Last edited by JBeaucaire; 08-29-2014 at 12:22 PM.
    Reply With QuoteRegister To Reply
  6. 08-23-2014, 03:02 AM #6
    kavin
    kavin is offline
    Registered User
    Join Date
    06-23-2010
    Location
    *
    MS-Off Ver
    Excel 2010
    Posts
    58

    Re: Date Range

    Thanks it is working like a charm Vikas
    one more help, I want to place the new "pl4" file on desktop and want it to pull data from closed "csv" files named "A","B","C","D" in a folder named "DATA"
    please check file an folder attached
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 08-23-2014, 05:33 AM #7
    Vikas_Gautam
    Vikas_Gautam is offline
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Date Range

    why don't you copy all of them in one...?

    Vikas Gautam
    Reply With QuoteRegister To Reply
  8. 08-23-2014, 06:31 AM #8
    kavin
    kavin is offline
    Registered User
    Join Date
    06-23-2010
    Location
    *
    MS-Off Ver
    Excel 2010
    Posts
    58

    Re: Date Range

    Quote Originally Posted by Vikas_Gautam View Post
    why don't you copy all of them in one...?

    Vikas Gautam
    150 files and I need to keep them separately,can it be pulled from txt. too
    Reply With QuoteRegister To Reply
  9. 08-23-2014, 06:47 AM #9
    Vikas_Gautam
    Vikas_Gautam is offline
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Date Range

    If you wanna include them in the search...
    or
    wanna search them seperately..

    Don't forget to click *, again
    Reply With QuoteRegister To Reply
  10. 08-23-2014, 03:33 PM #10
    kavin
    kavin is offline
    Registered User
    Join Date
    06-23-2010
    Location
    *
    MS-Off Ver
    Excel 2010
    Posts
    58

    Re: Date Range

    Quote Originally Posted by Vikas_Gautam View Post
    If you wanna include them in the search...
    or
    wanna search them seperately..

    Don't forget to click *, again
    my main file will be on desktop and folder with these 150 files will be in D drive.
    all 150 files will have different names which will be displayed in main file .The main file will show Mode,SD of all these files against their name in main file
    The calculation should be made once I open the main file ,New data will be added in these files on the next day only so don't need any refresh.
    Reply With QuoteRegister To Reply
  11. 08-24-2014, 03:31 AM #11
    Vikas_Gautam
    Vikas_Gautam is offline
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Thumbs up Re: Date Range

    Got the solution at your original thread...
    Simultaneously open Files named A, B, C, D to get the formula to work..


    Don't forget to click *
    Attached Files Attached Files
    Last edited by JBeaucaire; 08-29-2014 at 12:21 PM.
    Reply With QuoteRegister To Reply
  12. 08-24-2014, 04:44 AM #12
    Vikas_Gautam
    Vikas_Gautam is offline
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Thumbs up Re: Date Range

    I think Mission is accomplished now..

    I have made an update button...
    to refreshed all the formulas..

    Make a list of names in the A column and copy paste the formulas below..
    and put all your 150 files and place them in a folder "D:\Data"

    Don't forget to click *, again
    Attached Files Attached Files
    Last edited by JBeaucaire; 08-29-2014 at 12:22 PM.
    Reply With QuoteRegister To Reply
  13. 08-24-2014, 05:03 AM #13
    Vikas_Gautam
    Vikas_Gautam is offline
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Date Range

    I think there may be one potential problem...

    the date format of your PC and mine may be different. ( I am sure)

    SO change the Start and end date accordingly..

    Don't forget to click *, again
    Last edited by JBeaucaire; 08-29-2014 at 12:21 PM.
    Reply With QuoteRegister To Reply
  14. 08-29-2014, 03:59 AM #14
    kavin
    kavin is offline
    Registered User
    Join Date
    06-23-2010
    Location
    *
    MS-Off Ver
    Excel 2010
    Posts
    58

    Re: Date Range

    Hi I have made some changes in files and now I want to pull data from one flie only.
    File pl4 should pull data from file ACC in D:\Data folder
    Please check attached files don't know why is it not working
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  15. 08-29-2014, 11:59 AM #15
    kavin
    kavin is offline
    Registered User
    Join Date
    06-23-2010
    Location
    *
    MS-Off Ver
    Excel 2010
    Posts
    58

    Re: Date Range

    bump.....................
    Reply With QuoteRegister To Reply
  16. 08-29-2014, 12:19 PM #16
    Vikas_Gautam
    Vikas_Gautam is offline
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Date Range

    Its working now..
    the problem was in the ' ' signs..

    Check the attachment..
    Attached Files Attached Files
    Regards,
    Vikas Gautam
    Excel-buzz.blogspot.com
    Excel is not a matter of Experience, its a matter of Application.
    Say Thanks, Click * 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. VBA to enter date range based on date range in above cell
    By Pierce Quality in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-19-2013, 08:45 AM
  2. Search date range +/- 7 days and return date that falls within range
    By tlafferty in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-13-2013, 03:26 PM
  3. [SOLVED] Excel 2007 : Subtract a date range on, around or within another date range
    By tiggynook in forum Excel General
    Replies: 9
    Last Post: 06-21-2012, 03:46 PM
  4. [SOLVED] Calculate how many days in one date range fall into a second date range
    By globalpontoon in forum Excel General
    Replies: 2
    Last Post: 05-08-2012, 03:02 PM
  5. IF Statement - # of days in (date range 1) that fall within (date range 2)
    By shaula in forum Excel General
    Replies: 4
    Last Post: 03-18-2011, 07:02 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1