+ Reply to Thread
Results 1 to 4 of 4

date range

  1. #1
    Registered User
    Join Date
    01-02-2019
    Location
    Massachusetts
    MS-Off Ver
    2007
    Posts
    30

    date range

    So I've done some research but it all comes up bad.

    Column A: random date
    Column B: NOT RELATED
    Column C: NOT RELATED
    Column D: Number
    Column G: The year number in sequence (1,2,3,4,5 etc.)
    Column H: The start date for the year
    Column I: End date of the year
    Column J: where the results of the calculations will be.

    problems: find out if the date in A1 is between the dates (H1 and I1). If it is then add the number (D1)
    [attach]DATE CHECKING.xlsx[/attach]
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    19,573

    Re: date range

    You can use this formula in J2:

    =SUMIFS($D$2:$D$12,$A$2:$A$12,">="&H2,$A$2:$A$12,"<="&I2)

    then copy down as required.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    01-02-2019
    Location
    Massachusetts
    MS-Off Ver
    2007
    Posts
    30

    Re: date range

    Thank you it worked as needed.
    Is it possible to have it determined on two dates.

    inserting a blank column in B and having the formula check if those two dates and all in between them. I attached another template to explain.
    [attach]DATE CHECKING.xlsx[/attach]
    Attached Files Attached Files

  4. #4
    Forum Expert Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    3,788

    Re: date range

    Please try at K2 and copy down
    =SUMIFS(E:E,A:A,">="&I2,B:B,"<="&J2)

+ 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. Replies: 4
    Last Post: 03-21-2018, 09:25 AM
  2. Check a date range and return value based on the date range
    By KeithCar in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-13-2015, 12:55 PM
  3. Highlight a date range if today's date falls within that range
    By sdarnell in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-01-2014, 10:03 AM
  4. 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
  5. 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
  6. Replies: 9
    Last Post: 06-21-2012, 03:46 PM
  7. [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

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